AR_TRX_INF_V

Details

• Schema: FUSION

• Object owner: AR

• Object type: VIEW

Columns

Name
CUSTOMER_TRX_ID CUSTOMER_NAME CUSTOMER_NUMBER TRX_NUMBER TRX_DOCUMENT_NUMBER TRX_DATE TRX_TYPE TRX_BATCH_SOURCE BU_NAME

Query

SQL_Statement

SELECT trx.customer_trx_id CUSTOMER_TRX_ID, pty.party_name CUSTOMER_NAME, ca.account_number CUSTOMER_NUMBER, trx.trx_number TRX_NUMBER, trx.doc_sequence_value TRX_DOCUMENT_NUMBER, trx.trx_date TRX_DATE, tty.name TRX_TYPE, bs.name TRX_BATCH_SOURCE, bu.bu_name BU_NAME FROM ra_customer_trx_all trx , hz_cust_accounts ca , hz_parties pty , ra_cust_trx_types_all tty, ra_batch_sources_all bs, fun_all_business_units_v bu WHERE DECODE(trx.drawee_id, NULL, trx.bill_to_customer_id, trx.drawee_id) = ca.cust_account_id AND ca.party_id = pty.party_id AND trx.cust_trx_type_seq_id = tty.cust_trx_type_seq_id AND trx.batch_source_seq_id = bs.batch_source_seq_id AND trx.org_id = bu.bu_id