View: JAI_AR_TRX_DETAILS_V

Product:	JA - Asia/Pacific Localizations
Description:
Implementation/DBA Data:	APPS.JAI_AR_TRX_DETAILS_V

View Text

SELECT GD.GL_DATE GD_GL_DATE
, CT.COMPLETE_FLAG
, CT.TRX_NUMBER
, CT.TRX_DATE
, CT.ROWID ROW_ID
, CT.CUSTOMER_TRX_ID
, CT.CUST_TRX_TYPE_ID
, CT.BATCH_ID
, CT.SHIP_TO_SITE_USE_ID
, CT.CREATED_FROM
, CT.INVOICE_CURRENCY_CODE
, CT.ORIG_SYSTEM_BATCH_NAME
, CT.LAST_UPDATE_DATE
, CT.LAST_UPDATED_BY
, CT.CREATION_DATE
, CT.CREATED_BY
, CT.LAST_UPDATE_LOGIN
, CT.TERM_ID CT_TERM_ID
, CT.SHIP_TO_CUSTOMER_ID CT_SHIP_TO_CUSTOMER_ID
, CT.PRIMARY_SALESREP_ID CT_PRIMARY_SALESREP_ID
, CT.BATCH_SOURCE_ID
, HZP.PARTY_NAME
, BS.NAME BS_BATCH_SOURCE_NAME
, BS.BATCH_SOURCE_TYPE
, CTT.NAME CTT_TYPE_NAME
, CTT.TYPE CTT_CLASS
FROM RA_CUST_TRX_LINE_GL_DIST_ALL GD
, RA_CUSTOMER_TRX CT
, RA_CUST_TRX_TYPES_ALL CTT
, RA_BATCH_SOURCES_ALL BS
, HZ_PARTIES HZP
, HZ_CUST_ACCOUNTS HZCA
WHERE 'REC' = GD.ACCOUNT_CLASS
AND 'Y' = GD.LATEST_REC_FLAG
AND CT.CUSTOMER_TRX_ID = GD.CUSTOMER_TRX_ID
AND CT.CUST_TRX_TYPE_ID = CTT.CUST_TRX_TYPE_ID
AND CT.BATCH_SOURCE_ID = BS.BATCH_SOURCE_ID
AND CT.BILL_TO_CUSTOMER_ID = HZCA.CUST_ACCOUNT_ID
AND HZP.PARTY_ID = HZCA.PARTY_ID
AND GD.ORG_ID = CTT.ORG_ID
AND GD.ORG_ID = BS.ORG_ID

Columns