eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.IGI_RPI_INVOICE_HISTORY_V

Source

View Text - Preformatted


SELECT sc.standing_charge_id standing_charge_id , tx.trx_number invoice_number , tx.trx_date invoice_date , tx.comments comments , tx.creation_date creation_date, tx.created_by created_by, tx.last_update_date last_update_date, tx.last_updated_by last_updated_by, tx.last_update_login last_update_login, sum( tl.extended_amount) amount, tx.invoice_currency_code invoice_currency_code, tx.org_id FROM IGI_RPI_STANDING_CHARGES_ALL SC, RA_CUSTOMER_TRX TX, RA_CUSTOMER_TRX_LINES_ALL TL WHERE to_char(sc.standing_charge_id) = tx.interface_header_attribute1 AND tl.customer_trx_id = tx.customer_trx_id AND tx.org_id = tl.org_id AND tx.interface_header_context = ( select iaso.rpi_header_context_code from igi_ar_system_options_all iaso where iaso.org_id = tx.org_id ) GROUP BY sc.standing_charge_id , tx.trx_number , tx.trx_date , tx.invoice_currency_code, tx.comments , tx.creation_date , tx.created_by, tx.last_update_date , tx.last_updated_by , tx.last_update_login, tx.org_id

View Text - HTML Formatted

SELECT SC.STANDING_CHARGE_ID STANDING_CHARGE_ID
, TX.TRX_NUMBER INVOICE_NUMBER
, TX.TRX_DATE INVOICE_DATE
, TX.COMMENTS COMMENTS
, TX.CREATION_DATE CREATION_DATE
, TX.CREATED_BY CREATED_BY
, TX.LAST_UPDATE_DATE LAST_UPDATE_DATE
, TX.LAST_UPDATED_BY LAST_UPDATED_BY
, TX.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, SUM( TL.EXTENDED_AMOUNT) AMOUNT
, TX.INVOICE_CURRENCY_CODE INVOICE_CURRENCY_CODE
, TX.ORG_ID
FROM IGI_RPI_STANDING_CHARGES_ALL SC
, RA_CUSTOMER_TRX TX
, RA_CUSTOMER_TRX_LINES_ALL TL
WHERE TO_CHAR(SC.STANDING_CHARGE_ID) = TX.INTERFACE_HEADER_ATTRIBUTE1
AND TL.CUSTOMER_TRX_ID = TX.CUSTOMER_TRX_ID
AND TX.ORG_ID = TL.ORG_ID
AND TX.INTERFACE_HEADER_CONTEXT = ( SELECT IASO.RPI_HEADER_CONTEXT_CODE
FROM IGI_AR_SYSTEM_OPTIONS_ALL IASO
WHERE IASO.ORG_ID = TX.ORG_ID ) GROUP BY SC.STANDING_CHARGE_ID
, TX.TRX_NUMBER
, TX.TRX_DATE
, TX.INVOICE_CURRENCY_CODE
, TX.COMMENTS
, TX.CREATION_DATE
, TX.CREATED_BY
, TX.LAST_UPDATE_DATE
, TX.LAST_UPDATED_BY
, TX.LAST_UPDATE_LOGIN
, TX.ORG_ID