DBA Data[Home] [Help]
Skip to content

VIEW: IGI.IGI_RPI_AUDIT_ITEMS_ALL#

Source

View Text - Preformatted

select ITEM_ID ITEM_ID, PRICE PRICE, EFFECTIVE_DATE EFFECTIVE_DATE, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REVISED_EFFECTIVE_DATE REVISED_EFFECTIVE_DATE, REVISED_PRICE REVISED_PRICE, RUN_ID RUN_ID, ORG_ID ORG_ID from "IGI"."IGI_RPI_AUDIT_ITEMS_ALL"
View Text - HTML Formatted

SELECT ITEM_ID ITEM_ID
, PRICE PRICE
, EFFECTIVE_DATE EFFECTIVE_DATE
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REVISED_EFFECTIVE_DATE REVISED_EFFECTIVE_DATE
, REVISED_PRICE REVISED_PRICE
, RUN_ID RUN_ID
, ORG_ID ORG_ID
FROM "IGI"."IGI_RPI_AUDIT_ITEMS_ALL"