VIEW: APPS.AR_TRX_INF_V

Source

View Text - Preformatted

SELECT trx.customer_trx_id, SUBSTRB(pty.party_name,1,240), ca.account_number, trx.trx_number, trx.doc_sequence_value, trx.trx_date, tty.name, bs.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 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_id = tty.cust_trx_type_id AND trx.org_id = tty.org_id AND trx.batch_source_id = bs.batch_source_id AND trx.org_id = bs.org_id

View Text - HTML Formatted

SELECT TRX.CUSTOMER_TRX_ID
, SUBSTRB(PTY.PARTY_NAME
, 1
, 240)
, CA.ACCOUNT_NUMBER
, TRX.TRX_NUMBER
, TRX.DOC_SEQUENCE_VALUE
, TRX.TRX_DATE
, TTY.NAME
, BS.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
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_ID = TTY.CUST_TRX_TYPE_ID
AND TRX.ORG_ID = TTY.ORG_ID
AND TRX.BATCH_SOURCE_ID = BS.BATCH_SOURCE_ID
AND TRX.ORG_ID = BS.ORG_ID