[Home] [Help]
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
Name |
ROW_ID |
CHARGE_REFERENCE |
ITEM_ID |
PRICE |
EFFECTIVE_DATE |
REVISED_PRICE |
REVISED_EFFECTIVE_DATE |
RUN_ID |
LAST_UPDATE_DATE |
PREVIOUS_PRICE |
PREVIOUS_EFFECTIVE_DATE |