VIEW: ICX.ICX_CAT_ITEM_PRICES#

Source

View Text - Preformatted

select RT_ITEM_ID RT_ITEM_ID, PRICE_TYPE PRICE_TYPE, ACTIVE_FLAG ACTIVE_FLAG, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, ASL_ID ASL_ID, SUPPLIER_SITE_ID SUPPLIER_SITE_ID, CONTRACT_ID CONTRACT_ID, CONTRACT_LINE_ID CONTRACT_LINE_ID, TEMPLATE_ID TEMPLATE_ID, TEMPLATE_LINE_ID TEMPLATE_LINE_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, MTL_CATEGORY_ID MTL_CATEGORY_ID, ORG_ID ORG_ID, SEARCH_TYPE SEARCH_TYPE, UNIT_PRICE UNIT_PRICE, CURRENCY CURRENCY, UNIT_OF_MEASURE UNIT_OF_MEASURE, FUNCTIONAL_PRICE FUNCTIONAL_PRICE, SUPPLIER_SITE_CODE SUPPLIER_SITE_CODE, CONTRACT_NUM CONTRACT_NUM, CONTRACT_LINE_NUM CONTRACT_LINE_NUM, PRICE_LIST_ID PRICE_LIST_ID, SUPPLIER_NUMBER SUPPLIER_NUMBER, SUPPLIER_CONTACT_ID SUPPLIER_CONTACT_ID, ITEM_REVISION ITEM_REVISION, LINE_TYPE_ID LINE_TYPE_ID, BUYER_ID BUYER_ID, RATE_TYPE RATE_TYPE, RATE_DATE RATE_DATE, RATE RATE, LOCAL_RT_ITEM_ID LOCAL_RT_ITEM_ID, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, SUGGESTED_QUANTITY SUGGESTED_QUANTITY, ALLOW_PRICE_OVERRIDE_FLAG ALLOW_PRICE_OVERRIDE_FLAG, NOT_TO_EXCEED_PRICE NOT_TO_EXCEED_PRICE, VALUE_BASIS VALUE_BASIS, PURCHASE_BASIS PURCHASE_BASIS, NEGOTIATED_BY_PREPARER_FLAG NEGOTIATED_BY_PREPARER_FLAG from "ICX"."ICX_CAT_ITEM_PRICES"

View Text - HTML Formatted

SELECT RT_ITEM_ID RT_ITEM_ID
, PRICE_TYPE PRICE_TYPE
, ACTIVE_FLAG ACTIVE_FLAG
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, ASL_ID ASL_ID
, SUPPLIER_SITE_ID SUPPLIER_SITE_ID
, CONTRACT_ID CONTRACT_ID
, CONTRACT_LINE_ID CONTRACT_LINE_ID
, TEMPLATE_ID TEMPLATE_ID
, TEMPLATE_LINE_ID TEMPLATE_LINE_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, MTL_CATEGORY_ID MTL_CATEGORY_ID
, ORG_ID ORG_ID
, SEARCH_TYPE SEARCH_TYPE
, UNIT_PRICE UNIT_PRICE
, CURRENCY CURRENCY
, UNIT_OF_MEASURE UNIT_OF_MEASURE
, FUNCTIONAL_PRICE FUNCTIONAL_PRICE
, SUPPLIER_SITE_CODE SUPPLIER_SITE_CODE
, CONTRACT_NUM CONTRACT_NUM
, CONTRACT_LINE_NUM CONTRACT_LINE_NUM
, PRICE_LIST_ID PRICE_LIST_ID
, SUPPLIER_NUMBER SUPPLIER_NUMBER
, SUPPLIER_CONTACT_ID SUPPLIER_CONTACT_ID
, ITEM_REVISION ITEM_REVISION
, LINE_TYPE_ID LINE_TYPE_ID
, BUYER_ID BUYER_ID
, RATE_TYPE RATE_TYPE
, RATE_DATE RATE_DATE
, RATE RATE
, LOCAL_RT_ITEM_ID LOCAL_RT_ITEM_ID
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, SUGGESTED_QUANTITY SUGGESTED_QUANTITY
, ALLOW_PRICE_OVERRIDE_FLAG ALLOW_PRICE_OVERRIDE_FLAG
, NOT_TO_EXCEED_PRICE NOT_TO_EXCEED_PRICE
, VALUE_BASIS VALUE_BASIS
, PURCHASE_BASIS PURCHASE_BASIS
, NEGOTIATED_BY_PREPARER_FLAG NEGOTIATED_BY_PREPARER_FLAG
FROM "ICX"."ICX_CAT_ITEM_PRICES"