View: AR_OEX_CM_VIEW

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

View Text

SELECT HP.PARTY_NAME PARTY_NAME
, CM.INTERFACE_HEADER_CONTEXT CM_INTERFACE_HEADER_CONTEXT
, CM.INTERFACE_HEADER_ATTRIBUTE1 CM_INTERFACE_HEADER_ATTRIBUTE1
, CM.INTERFACE_HEADER_ATTRIBUTE2 CM_INTERFACE_HEADER_ATTRIBUTE2
, CM.BILL_TO_CUSTOMER_ID AR_BILL_TO_PARTY_ID
, CM.BILL_TO_SITE_USE_ID AR_BILL_TO_SITE_USE_ID
, CM.INTERFACE_HEADER_ATTRIBUTE3 CM_INTERFACE_HEADER_ATTRIBUTE3
, CM.INTERFACE_HEADER_ATTRIBUTE4 CM_INTERFACE_HEADER_ATTRIBUTE4
, CM.CUSTOMER_TRX_ID CM_CUSTOMER_TRX_ID
, CM.TRX_DATE CM_TRX_DATE
, CM.TRX_NUMBER CM_TRX_NUMBER
, CMPS.STATUS CM_TRX_STATUS
, CMPS.CLASS CM_TRX_CLASS_CODE
, L_CM_CLASS.MEANING CM_TRX_CLASS_NAME
, CMAPP.APPLY_DATE CM_APPLY_DATE
, CMAPP.AMOUNT_APPLIED CM_AMOUNT_APPLIED
, CMPS.AMOUNT_DUE_ORIGINAL CM_AMOUNT_ORIGINAL
, CMPS.AMOUNT_DUE_REMAINING CM_AMOUNT_REMAINING
, INV.CUSTOMER_TRX_ID INV_CUSTOMER_TRX_ID
, INV.TRX_DATE INV_TRX_DATE
, INV.TRX_NUMBER INV_TRX_NUMBER
, CMPS.ORG_ID ORG_ID
, CMPS.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CMPS.LAST_UPDATED_BY LAST_UPDATED_BY
, CMPS.CREATION_DATE CREATION_DATE
, CMPS.CREATED_BY CREATED_BY
, CMPS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CMPS.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, CMPS.PROGRAM_ID PROGRAM_ID
, CMPS.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
FROM RA_CUSTOMER_TRX_ALL CM
, AR_PAYMENT_SCHEDULES_ALL CMPS
, AR_LOOKUPS L_CM_CLASS
, AR_RECEIVABLE_APPLICATIONS_ALL CMAPP
, RA_CUSTOMER_TRX_ALL INV
, HZ_PARTIES HP
, HZ_CUST_ACCOUNTS_ALL HCA
WHERE CMPS.CLASS = 'CM'
AND CMPS.CLASS = L_CM_CLASS.LOOKUP_CODE
AND L_CM_CLASS.LOOKUP_TYPE = 'INV/CM'
AND CMPS.CUSTOMER_TRX_ID = CM.CUSTOMER_TRX_ID AND CMPS.PAYMENT_SCHEDULE_ID = CMAPP.PAYMENT_SCHEDULE_ID(+) AND CMAPP.APPLIED_CUSTOMER_TRX_ID = INV.CUSTOMER_TRX_ID(+) AND CMPS.ORG_ID = CM.ORG_ID AND CMPS.ORG_ID = CMAPP.ORG_ID(+) AND CMAPP.ORG_ID = INV.ORG_ID(+) AND HP.PARTY_ID = HCA.PARTY_ID AND HCA.ORIG_SYSTEM_REFERENCE = 'EXCHANGE_CUST'||CM.INTERFACE_HEADER_ATTRIBUTE1

Columns