View: XTR_AR_ORIG_TRX_V

Product:	XTR - Treasury
Description:	The XTR_AR_ORIG_TRX_V view is used in the Current Hedge Items window of the Hedge Relationship - Forecast (XTRINHRF) form when the Source is Receivables
Implementation/DBA Data:	APPS.XTR_AR_ORIG_TRX_V

View Text

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

Columns