VIEW: APPS.AR_PAYMENT_SCHEDULES_TRX_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'