AR_TRANSACTIONS_S_V

Details

• Schema: FUSION

• Object owner: AR

• Object type: VIEW

Columns

Name

TRX_ATTR1 TRX_ATTR10 TRX_ATTR11 TRX_ATTR12 TRX_ATTR13 TRX_ATTR14 TRX_ATTR15 TRX_ATTR2 TRX_ATTR3 TRX_ATTR4 TRX_ATTR5 TRX_ATTR6 TRX_ATTR7 TRX_ATTR8 TRX_ATTR9 TRX_ATTR_CAT TRX_CREDIT_METHOD_FOR_INSTALL TRX_CREDIT_METHOD_FOR_RULES TRX_CUSTOMER_TRX_ID TRX_DOC_SEQUENCE_ID TRX_DOC_SEQUENCE_VALUE TRX_DOC_SEQUENCE_CATEGORY TRX_FOB_POINT TRX_GLOBAL_ATTR1 TRX_GLOBAL_ATTR10 TRX_GLOBAL_ATTR11 TRX_GLOBAL_ATTR12 TRX_GLOBAL_ATTR13 TRX_GLOBAL_ATTR14 TRX_GLOBAL_ATTR15 TRX_GLOBAL_ATTR16 TRX_GLOBAL_ATTR17 TRX_GLOBAL_ATTR18 TRX_GLOBAL_ATTR19 TRX_GLOBAL_ATTR2 TRX_GLOBAL_ATTR20 TRX_GLOBAL_ATTR3 TRX_GLOBAL_ATTR4 TRX_GLOBAL_ATTR5 TRX_GLOBAL_ATTR6 TRX_GLOBAL_ATTR7 TRX_GLOBAL_ATTR8 TRX_GLOBAL_ATTR9 TRX_GLOBAL_ATTR_CAT TRX_INTERFACE_HEADER_ATTR1 TRX_INTERFACE_HEADER_ATTR10 TRX_INTERFACE_HEADER_ATTR11 TRX_INTERFACE_HEADER_ATTR12 TRX_INTERFACE_HEADER_ATTR13 TRX_INTERFACE_HEADER_ATTR14 TRX_INTERFACE_HEADER_ATTR15 TRX_INTERFACE_HEADER_ATTR2 TRX_INTERFACE_HEADER_ATTR3 TRX_INTERFACE_HEADER_ATTR4 TRX_INTERFACE_HEADER_ATTR5 TRX_INTERFACE_HEADER_ATTR6 TRX_INTERFACE_HEADER_ATTR7 TRX_INTERFACE_HEADER_ATTR8 TRX_INTERFACE_HEADER_ATTR9 TRX_INTERFACE_HEADER_CT TRX_INVOICE_CURRENCY_CODE TRX_INVOICING_RULE_ID TRX_PRINTING_OPTION TRX_PURCHASE_ORDER TRX_PURCHASE_ORDER_DATE TRX_PURCHASE_ORDER_REVISION TRX_REASON_CODE TRX_SHIP_DATE_ACTUAL TRX_STATUS_TRX TRX_TERM_DUE_DATE TRX_DATE TRX_NUMBER TRX_WAYBILL_NUMBER TRX_TYPE_CUST_TRX_TYPE_ID TRX_TYPE_DESCRIPTION TRX_TYPE_DRAWEE_ISSUED_FLAG TRX_TYPE_GLOBAL_ATTR1 TRX_TYPE_GLOBAL_ATTR10 TRX_TYPE_GLOBAL_ATTR2 TRX_TYPE_GLOBAL_ATTR3 TRX_TYPE_GLOBAL_ATTR4 TRX_TYPE_GLOBAL_ATTR5 TRX_TYPE_GLOBAL_ATTR6 TRX_TYPE_GLOBAL_ATTR7 TRX_TYPE_GLOBAL_ATTR_CAT TRX_TYPE_MAG_FORMAT_CODE TRX_TYPE_NAME TRX_TYPE_POST_TO_GL TRX_TYPE_CLASS EVENT_ID LINE_NUMBER LEDGER_ID XLA_PARTY_TYPE TRX_OPER_UNIT TRX_RECEIVABLE_CCID TRX_XLA_APPLIED_TO_APP_ID TRX_ENTITY_CODE TRX_LEGAL_ENTITY_ID TRX_RECEIPT_METHOD_ID TRX_RECEIPT_METHOD_NAME CB_TRX_NUMBER CB_TRX_DATE CB_BATCH_SOURCE_NAME TRX_REV_REC_APPLICATION TRX_REV_CONTRACT_CLEARING_CCID TRX_DOCUMENT_TYPE_CODE TRX_CREATION_DATE TRX_CREATED_BY TRX_LAST_UPDATE_DATE TRX_LAST_UPDATED_BY MULTIFUND_UPGRADED_TRX_FLAG TRX_CT_REFERENCE

Query

SQL_Statement

SELECT /*+ INDEX(l AR_XLA_LINES_EXTRACT_N1) */ gt.trx_attr1 , gt.trx_attr10 , gt.trx_attr11 , gt.trx_attr12 , gt.trx_attr13 , gt.trx_attr14 , gt.trx_attr15 , gt.trx_attr2 , gt.trx_attr3 , gt.trx_attr4 , gt.trx_attr5 , gt.trx_attr6 , gt.trx_attr7 , gt.trx_attr8 , gt.trx_attr9 , gt.trx_attr_cat , gt.trx_credit_method_for_install , gt.trx_credit_method_for_rules , gt.trx_customer_trx_id , gt.trx_doc_sequence_id , gt.trx_doc_sequence_value , gt.TRX_DOC_SEQUENCE_CATEGORY , gt.trx_fob_point , gt.trx_global_attr1 , gt.trx_global_attr10 , gt.trx_global_attr11 , gt.trx_global_attr12 , gt.trx_global_attr13 , gt.trx_global_attr14 , gt.trx_global_attr15 , gt.trx_global_attr16 , gt.trx_global_attr17 , gt.trx_global_attr18 , gt.trx_global_attr19 , gt.trx_global_attr2 , gt.trx_global_attr20 , gt.trx_global_attr3 , gt.trx_global_attr4 , gt.trx_global_attr5 , gt.trx_global_attr6 , gt.trx_global_attr7 , gt.trx_global_attr8 , gt.trx_global_attr9 , gt.trx_global_attr_cat , gt.trx_interface_header_attr1 , gt.trx_interface_header_attr10 , gt.trx_interface_header_attr11 , gt.trx_interface_header_attr12 , gt.trx_interface_header_attr13 , gt.trx_interface_header_attr14 , gt.trx_interface_header_attr15 , gt.trx_interface_header_attr2 , gt.trx_interface_header_attr3 , gt.trx_interface_header_attr4 , gt.trx_interface_header_attr5 , gt.trx_interface_header_attr6 , gt.trx_interface_header_attr7 , gt.trx_interface_header_attr8 , gt.trx_interface_header_attr9 , gt.trx_interface_header_ct , gt.trx_invoice_currency_code , gt.trx_invoicing_rule_id , gt.trx_printing_option , gt.trx_purchase_order , gt.trx_purchase_order_date , gt.trx_purchase_order_revision , gt.trx_reason_code , gt.trx_ship_date_actual , gt.trx_status_trx , gt.trx_term_due_date , gt.trx_date , gt.trx_number , gt.trx_waybill_number , gt.trx_type_cust_trx_type_id , gt.trx_type_description , gt.trx_type_drawee_issued_flag , gt.trx_type_global_attr1 , gt.trx_type_global_attr10 , gt.trx_type_global_attr2 , gt.trx_type_global_attr3 , gt.trx_type_global_attr4 , gt.trx_type_global_attr5 , gt.trx_type_global_attr6 , gt.trx_type_global_attr7 , gt.trx_type_global_attr_cat , gt.trx_type_mag_format_code , gt.trx_type_name , gt.trx_type_post_to_gl , gt.trx_type_class , l.event_id event_id , l.line_number line_number , l.ledger_id ledger_id , gt.xla_party_type , gt.trx_oper_unit , l.paired_ccid TRX_RECEIVABLE_CCID, gt.trx_xla_applied_to_app_id , DECODE(l.event_class_code,'BILL', 'BILLS_RECEIVABLE', 'TRANSACTIONS') trx_entity_code , gt.trx_legal_entity_id, gt.trx_receipt_method_id, gt.trx_receipt_method_name, gt.cb_trx_number, gt.cb_trx_date, gt.cb_batch_source_name, gt.TRX_REV_REC_APPLICATION, gt.TRX_REV_CONTRACT_CLEARING_CCID, gt.TRX_DOCUMENT_TYPE_CODE, gt.trx_creation_date, gt.trx_created_by , gt.trx_last_update_date, gt.trx_last_updated_by, gt.multifund_upgraded_trx_flag, gt.trx_ct_reference FROM ar_xla_lines_extract l , ar_cust_trx_gt gt WHERE gt.trx_customer_trx_id = l.customer_trx_id AND ((l.event_class_code IN ('INVOICE','DEBIT_MEMO','DEPOSIT', 'GUARANTEE','CHARGEBACK','ADJUSTMENT','BILL') AND l.level_flag = 'H') OR (l.event_class_code IN ('CREDIT_MEMO','RECEIPT') AND l.level_flag = 'L' AND l.from_to_flag in ('T','Y')))