View: IGI_RPI_INVOICE_HISTORY_V

Product:	IGI - Public Sector Financials International
Description:	Contains invoice history informaion for a single standing charge
Implementation/DBA Data:	APPS.IGI_RPI_INVOICE_HISTORY_V

View Text

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
FROM IGI_RPI_STANDING_CHARGES SC
, RA_CUSTOMER_TRX TX
, RA_CUSTOMER_TRX_LINES TL
WHERE TO_CHAR(SC.STANDING_CHARGE_ID) = TX.INTERFACE_HEADER_ATTRIBUTE1 AND TL.CUSTOMER_TRX_ID = TX.CUSTOMER_TRX_ID AND TX.INTERFACE_HEADER_CONTEXT = ( SELECT RPI_HEADER_CONTEXT_CODE
FROM IGI_AR_SYSTEM_OPTIONS ) 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

Columns