VIEW: APPS.JAI_AR_TRX_DETAILS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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