VIEW: APPS.IGI_RPI_UPDATE_HDR_V

Source

View Text - Preformatted

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_all c, igi_lookups d, igi_rpi_items_all 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' AND a.org_id = b.org_id

View Text - HTML Formatted

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_ALL C
, IGI_LOOKUPS D
, IGI_RPI_ITEMS_ALL 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'
AND A.ORG_ID = B.ORG_ID