View: AR_TRX_INF_V

Product:	AR - Receivables
Description:
Implementation/DBA Data:	APPS.AR_TRX_INF_V

View Text

SELECT TRX.CUSTOMER_TRX_ID
, PTY.PARTY_NAME
, 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

Columns