VIEW: APPS.RA_CUSTOMER_TRX_INST_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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