VIEW: ICX.ICX_POR_ORACLE_ITEM_SUBTABLE#

Source

View Text - Preformatted

select RT_ITEM_ID RT_ITEM_ID, ORC_CONTRACT_ID ORC_CONTRACT_ID, ORC_CONTRACT_LINE_ID ORC_CONTRACT_LINE_ID, ORC_TEMPLATE_ID ORC_TEMPLATE_ID, ORC_TEMPLATE_LINE_ID ORC_TEMPLATE_LINE_ID, ORC_CATEGORY_ID ORC_CATEGORY_ID, ORC_ASL_ID ORC_ASL_ID, ORC_SUPPLIER_SITE_ID ORC_SUPPLIER_SITE_ID, ORC_OPERATING_UNIT_ID ORC_OPERATING_UNIT_ID, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, ORC_CONTRACT_NUM ORC_CONTRACT_NUM, ORC_CONTRACT_LINE_NUM ORC_CONTRACT_LINE_NUM, ORC_SUPPLIER_SITE_CODE ORC_SUPPLIER_SITE_CODE, SEARCH_TYPE SEARCH_TYPE, ACTIVE_FLAG ACTIVE_FLAG, UNIT_PRICE UNIT_PRICE, CURRENCY CURRENCY, UNIT_OF_MEASURE UNIT_OF_MEASURE, FUNCTIONAL_PRICE FUNCTIONAL_PRICE from "ICX"."ICX_POR_ORACLE_ITEM_SUBTABLE"

View Text - HTML Formatted

SELECT RT_ITEM_ID RT_ITEM_ID
, ORC_CONTRACT_ID ORC_CONTRACT_ID
, ORC_CONTRACT_LINE_ID ORC_CONTRACT_LINE_ID
, ORC_TEMPLATE_ID ORC_TEMPLATE_ID
, ORC_TEMPLATE_LINE_ID ORC_TEMPLATE_LINE_ID
, ORC_CATEGORY_ID ORC_CATEGORY_ID
, ORC_ASL_ID ORC_ASL_ID
, ORC_SUPPLIER_SITE_ID ORC_SUPPLIER_SITE_ID
, ORC_OPERATING_UNIT_ID ORC_OPERATING_UNIT_ID
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, ORC_CONTRACT_NUM ORC_CONTRACT_NUM
, ORC_CONTRACT_LINE_NUM ORC_CONTRACT_LINE_NUM
, ORC_SUPPLIER_SITE_CODE ORC_SUPPLIER_SITE_CODE
, SEARCH_TYPE SEARCH_TYPE
, ACTIVE_FLAG ACTIVE_FLAG
, UNIT_PRICE UNIT_PRICE
, CURRENCY CURRENCY
, UNIT_OF_MEASURE UNIT_OF_MEASURE
, FUNCTIONAL_PRICE FUNCTIONAL_PRICE
FROM "ICX"."ICX_POR_ORACLE_ITEM_SUBTABLE"