View: IGI_RPI_LINE_AUDIT_DETAILS_V

Product:	IGI - Public Sector Financials International
Description:	View for the standing charges audit form based on IGI_RPI_LINE_AUDIT_DET view
Implementation/DBA Data:	APPS.IGI_RPI_LINE_AUDIT_DETAILS_V

View Text

SELECT A. ROWID ROW_ID
, C.CHARGE_REFERENCE
, A.ITEM_ID
, A.PRICE
, A.EFFECTIVE_DATE
, A.REVISED_PRICE
, A.REVISED_EFFECTIVE_DATE
, A.RUN_ID
, A.LAST_UPDATE_DATE
, A.PREVIOUS_PRICE
, A.PREVIOUS_EFFECTIVE_DATE
FROM IGI_RPI_LINE_AUDIT_DET A
, IGI_RPI_STANDING_CHARGES C
WHERE A.STANDING_CHARGE_ID = C.STANDING_CHARGE_ID

Columns