Product: | IGI - Public Sector Financials International |
---|---|
Description: | View for the global price update form based on IGI_RPI_UPDATE_HDR view |
Implementation/DBA Data: | APPS.IGI_RPI_UPDATE_HDR_V |
SELECT A.ROWID ROW_ID
, A.RUN_ID
, A.ITEM_ID_FROM
, B.ITEM_CODE ITEM_CODE_FROM
, A.ITEM_ID_TO
, C.ITEM_CODE ITEM_CODE_TO
, A.EFFECTIVE_DATE
, A.OPTION_FLAG
, D.MEANING UPDATE_OPTION
, A.CREATION_DATE
, A.LAST_UPDATE_DATE
, A.LAST_UPDATED_BY
, A.LAST_UPDATE_LOGIN
, A.CREATED_BY
, A.ORG_ID
, A.AMOUNT
, A.PERCENTAGE_AMOUNT
, A.STATUS
, E.MEANING UPDATE_STATUS
, A.PROCESS_ID
, A.INCR_DECR_FLAG
FROM IGI_LOOKUPS E
, IGI_RPI_ITEMS C
, IGI_LOOKUPS D
, IGI_RPI_ITEMS B
, IGI_RPI_UPDATE_HDR A
WHERE A.ITEM_ID_FROM = B.ITEM_ID
AND A.ITEM_ID_TO = C.ITEM_ID
AND A.OPTION_FLAG = D.LOOKUP_CODE
AND D.LOOKUP_TYPE = 'GLOBAL_UPDATE_OPTION'
AND A.STATUS = E.LOOKUP_CODE
AND E.LOOKUP_TYPE = 'GLOBAL_UPDATE_STATUS'