Product: | AR - Receivables |
---|---|
Description: | |
Implementation/DBA Data: | APPS.ARFV_CREDIT_MEMO_APPLICATIONS |
SELECT /* UNIQUE ATTRIBUTES */ RA.RECEIVABLE_APPLICATION_ID
, /* REGULAR ATTRIBUTES */ RA.AMOUNT_APPLIED
, RA.ACCTD_AMOUNT_APPLIED_TO
, RA.ACCTD_AMOUNT_APPLIED_FROM
, RA.APPLY_DATE
, RA.LINE_APPLIED
, RA.TAX_APPLIED
, RA.FREIGHT_APPLIED
, RA.RECEIVABLES_CHARGES_APPLIED
, RA.DAYS_LATE
, RA.USSGL_TRANSACTION_CODE
, RA.COMMENTS
, '_DF:AR:AR_RECEIVABLE_APPLICATIONS:RA'
, '_DF:JG:JG_AR_RECEIVABLE_APPLICATIONS:RA'
, /* RESOLVED FK RESOLUTIONS */ AOU.NAME
, CTR.TRX_NUMBER
, CTR.TRX_DATE
, CTR.REASON_CODE
, PS.TRX_NUMBER
, CTL.LINE_NUMBER
, /* IDS */ RA.ORG_ID
, RA.PAYMENT_SCHEDULE_ID
, RA.APPLIED_PAYMENT_SCHEDULE_ID
, RA.APPLIED_CUSTOMER_TRX_LINE_ID
, /* WHO COLUMNS */ RA.LAST_UPDATE_DATE
, RA.LAST_UPDATED_BY
, RA.CREATION_DATE
, RA.CREATED_BY
FROM AR_RECEIVABLE_APPLICATIONS RA
, HR_ALL_ORGANIZATION_UNITS AOU
, RA_CUSTOMER_TRX CTR
, AR_PAYMENT_SCHEDULES PS
, RA_CUSTOMER_TRX_LINES CTL
WHERE RA.APPLICATION_TYPE = 'CM'
AND RA.ORG_ID = AOU.ORGANIZATION_ID(+)
AND RA.CUSTOMER_TRX_ID = CTR.CUSTOMER_TRX_ID
AND RA.APPLIED_PAYMENT_SCHEDULE_ID = PS.PAYMENT_SCHEDULE_ID
AND RA.APPLIED_CUSTOMER_TRX_LINE_ID = CTL.CUSTOMER_TRX_LINE_ID(+) WITH READ ONLY