Product: | IGI - Public Sector Financials International |
---|---|
Description: | View used for line updates at detailed level |
Implementation/DBA Data: | APPS.IGI_RPI_UPDATE_LINES_D_V |
SELECT A.ROWID ROW_ID
, A.RUN_ID
, A.ITEM_ID
, A.PRICE
, A.PREVIOUS_EFFECTIVE_DATE
, A.EFFECTIVE_DATE
, A.CREATION_DATE
, A.LAST_UPDATED_BY
, A.LAST_UPDATE_DATE
, A.LAST_UPDATE_LOGIN
, A.CREATED_BY
, A.ORG_ID
, A.STANDING_CHARGE_ID
, C.CHARGE_REFERENCE
, A.LINE_ITEM_ID
, A.REVISED_PRICE
, A.REVISED_EFFECTIVE_DATE
, A.PREVIOUS_PRICE
, A.UPDATED_PRICE
, A.SELECT_FLAG
FROM IGI_RPI_STANDING_CHARGES C
, IGI_RPI_UPDATE_LINES A
WHERE A.STANDING_CHARGE_ID = C.STANDING_CHARGE_ID
AND A.STANDING_CHARGE_ID IS NOT NULL