Product: | AR - Receivables |
---|---|
Description: | (Release 10SC Only) |
Implementation/DBA Data: | APPS.RA_CUSTOMER_TRX_INST_V |
SELECT CT.ROWID
, CT.CUSTOMER_TRX_ID
, CT.PREVIOUS_CUSTOMER_TRX_ID
, CT.TRX_NUMBER
, CT.INVOICE_CURRENCY_CODE
, PREV_CT.TRX_NUMBER
, PREV_BS.NAME
, SUM(PRV_PS.AMOUNT_LINE_ITEMS_ORIGINAL) / COUNT(DISTINCT PS.PAYMENT_SCHEDULE_ID)
, SUM(PRV_PS.TAX_ORIGINAL) / COUNT(DISTINCT PS.PAYMENT_SCHEDULE_ID)
, SUM(PRV_PS.FREIGHT_ORIGINAL) / COUNT(DISTINCT PS.PAYMENT_SCHEDULE_ID)
, SUM(PS.AMOUNT_LINE_ITEMS_ORIGINAL) / COUNT(DISTINCT PRV_PS.PAYMENT_SCHEDULE_ID)
, SUM(PS.TAX_ORIGINAL) / COUNT(DISTINCT PRV_PS.PAYMENT_SCHEDULE_ID)
, SUM(PS.FREIGHT_ORIGINAL) / COUNT(DISTINCT PRV_PS.PAYMENT_SCHEDULE_ID)
, CT.CREATED_BY
, CT.CREATION_DATE
, CT.LAST_UPDATED_BY
, CT.LAST_UPDATE_DATE
, CT.LAST_UPDATE_LOGIN
FROM RA_CUSTOMER_TRX CT
, RA_CUSTOMER_TRX PREV_CT
, RA_BATCH_SOURCES PREV_BS
, AR_PAYMENT_SCHEDULES PRV_PS
, AR_PAYMENT_SCHEDULES PS
WHERE PREV_CT.CUSTOMER_TRX_ID = CT.PREVIOUS_CUSTOMER_TRX_ID
AND PREV_BS.BATCH_SOURCE_ID = PREV_CT.BATCH_SOURCE_ID
AND PRV_PS.CUSTOMER_TRX_ID = PREV_CT.CUSTOMER_TRX_ID
AND PS.CUSTOMER_TRX_ID = CT.CUSTOMER_TRX_ID GROUP BY CT.ROWID
, CT.CUSTOMER_TRX_ID
, CT.PREVIOUS_CUSTOMER_TRX_ID
, CT.TRX_NUMBER
, CT.INVOICE_CURRENCY_CODE
, PREV_CT.TRX_NUMBER
, PREV_BS.NAME
, CT.CREATED_BY
, CT.CREATION_DATE
, CT.LAST_UPDATED_BY
, CT.LAST_UPDATE_DATE
, CT.LAST_UPDATE_LOGIN