Product: | AR - Receivables |
---|---|
Description: | (Release 115 Only ) |
Implementation/DBA Data: | APPS.AR_PAYMENT_SCHEDULES_TRX_V |
SELECT PS.ROWID
, PS.PAYMENT_SCHEDULE_ID
, CT.CUSTOMER_TRX_ID
, PS.DUE_DATE
, PS.AMOUNT_DUE_ORIGINAL
, PS.AMOUNT_DUE_REMAINING
, PS.AMOUNT_LINE_ITEMS_ORIGINAL
, PS.AMOUNT_LINE_ITEMS_REMAINING
, PS.TAX_ORIGINAL
, PS.TAX_REMAINING
, PS.FREIGHT_ORIGINAL
, PS.FREIGHT_REMAINING
, ( NVL(RA.LINE_APPLIED
, 0) + NVL(RA.RECEIVABLES_CHARGES_APPLIED
, 0)) * -1
, RA.TAX_APPLIED * -1
, RA.FREIGHT_APPLIED * -1
, RA.LINE_APPLIED * -1
, RA.RECEIVABLES_CHARGES_APPLIED * -1
, PS.CREATED_BY
, PS.CREATION_DATE
, PS.LAST_UPDATED_BY
, PS.LAST_UPDATE_DATE
, PS.LAST_UPDATE_LOGIN
FROM RA_CUSTOMER_TRX CT
, AR_PAYMENT_SCHEDULES PS
, AR_RECEIVABLE_APPLICATIONS RA
WHERE CT.COMPLETE_FLAG = 'Y'
AND PS.CUSTOMER_TRX_ID = CT.PREVIOUS_CUSTOMER_TRX_ID
AND RA.CUSTOMER_TRX_ID = CT.CUSTOMER_TRX_ID
AND RA.APPLIED_PAYMENT_SCHEDULE_ID = PS.PAYMENT_SCHEDULE_ID
AND NVL(RA.DISPLAY
, 'Y') = 'Y'