VIEW: APPS.XTR_AR_ORIG_TRX_V

Source

View Text - Preformatted

SELECT RCT.CUSTOMER_TRX_ID, APS.PAYMENT_SCHEDULE_ID, RCT.BATCH_SOURCE_ID, RBS.NAME, RCT.CUST_TRX_TYPE_ID, RCP.NAME, RCT.ORG_ID, HOU.NAME, APS.CUSTOMER_ID, HP.PARTY_NAME, XPV.PARTY_CODE, RCT.TRX_DATE, RCT.TRX_NUMBER, APS.INVOICE_CURRENCY_CODE, NVL(APS.AMOUNT_DUE_ORIGINAL,0), APS.DUE_DATE FROM RA_CUSTOMER_TRX_ALL RCT, AR_PAYMENT_SCHEDULES_ALL APS, HZ_CUST_ACCOUNTS HCA, HZ_PARTIES HP, HR_OPERATING_UNITS HOU, XTR_PARTIES_V XPV, RA_BATCH_SOURCES_ALL RBS, RA_CUST_TRX_TYPES_ALL RCP WHERE RCT.COMPLETE_FLAG = 'Y' AND RCT.CUSTOMER_TRX_ID = APS.CUSTOMER_TRX_ID AND RCT.ORG_ID = APS.ORG_ID AND RCT.BATCH_SOURCE_ID = RBS.BATCH_SOURCE_ID (+) AND RCT.ORG_ID = RBS.ORG_ID AND RCT.CUST_TRX_TYPE_ID = RCP.CUST_TRX_TYPE_ID (+) AND RCT.ORG_ID = RCP.ORG_ID AND RCT.ORG_ID = HOU.ORGANIZATION_ID AND hou.set_of_books_id = (SELECT glle.ledger_id FROM gl_ledger_le_v glle WHERE glle.legal_entity_id = (xpv.legal_entity_id) AND glle.ledger_category_code = 'PRIMARY') AND APS.CUSTOMER_ID = HCA.CUST_ACCOUNT_ID(+) AND HCA.PARTY_ID = HP.PARTY_ID(+) AND NVL(APS.AMOUNT_DUE_ORIGINAL,0) <> 0

View Text - HTML Formatted

SELECT RCT.CUSTOMER_TRX_ID
, APS.PAYMENT_SCHEDULE_ID
, RCT.BATCH_SOURCE_ID
, RBS.NAME
, RCT.CUST_TRX_TYPE_ID
, RCP.NAME
, RCT.ORG_ID
, HOU.NAME
, APS.CUSTOMER_ID
, HP.PARTY_NAME
, XPV.PARTY_CODE
, RCT.TRX_DATE
, RCT.TRX_NUMBER
, APS.INVOICE_CURRENCY_CODE
, NVL(APS.AMOUNT_DUE_ORIGINAL
, 0)
, APS.DUE_DATE
FROM RA_CUSTOMER_TRX_ALL RCT
, AR_PAYMENT_SCHEDULES_ALL APS
, HZ_CUST_ACCOUNTS HCA
, HZ_PARTIES HP
, HR_OPERATING_UNITS HOU
, XTR_PARTIES_V XPV
, RA_BATCH_SOURCES_ALL RBS
, RA_CUST_TRX_TYPES_ALL RCP
WHERE RCT.COMPLETE_FLAG = 'Y'
AND RCT.CUSTOMER_TRX_ID = APS.CUSTOMER_TRX_ID
AND RCT.ORG_ID = APS.ORG_ID
AND RCT.BATCH_SOURCE_ID = RBS.BATCH_SOURCE_ID (+)
AND RCT.ORG_ID = RBS.ORG_ID
AND RCT.CUST_TRX_TYPE_ID = RCP.CUST_TRX_TYPE_ID (+)
AND RCT.ORG_ID = RCP.ORG_ID
AND RCT.ORG_ID = HOU.ORGANIZATION_ID
AND HOU.SET_OF_BOOKS_ID = (SELECT GLLE.LEDGER_ID
FROM GL_LEDGER_LE_V GLLE
WHERE GLLE.LEGAL_ENTITY_ID = (XPV.LEGAL_ENTITY_ID)
AND GLLE.LEDGER_CATEGORY_CODE = 'PRIMARY')
AND APS.CUSTOMER_ID = HCA.CUST_ACCOUNT_ID(+)
AND HCA.PARTY_ID = HP.PARTY_ID(+)
AND NVL(APS.AMOUNT_DUE_ORIGINAL
, 0) <> 0