VIEW: ICX.ICX_CAT_ITEMS_CTX_HDRS_TLP#

Source

View Text - Preformatted

select INVENTORY_ITEM_ID INVENTORY_ITEM_ID, PO_LINE_ID PO_LINE_ID, REQ_TEMPLATE_NAME REQ_TEMPLATE_NAME, REQ_TEMPLATE_LINE_NUM REQ_TEMPLATE_LINE_NUM, ORG_ID ORG_ID, LANGUAGE LANGUAGE, SOURCE_TYPE SOURCE_TYPE, PURCHASING_ORG_ID PURCHASING_ORG_ID, IP_CATEGORY_ID IP_CATEGORY_ID, IP_CATEGORY_NAME IP_CATEGORY_NAME, PO_CATEGORY_ID PO_CATEGORY_ID, OWNING_ORG_ID OWNING_ORG_ID, CTX_DESC CTX_DESC, SUPPLIER_ID SUPPLIER_ID, SUPPLIER_PART_NUM SUPPLIER_PART_NUM, SUPPLIER_PART_AUXID SUPPLIER_PART_AUXID, SUPPLIER_SITE_ID SUPPLIER_SITE_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_LOGIN_ID PROGRAM_LOGIN_ID, INTERNAL_REQUEST_ID INTERNAL_REQUEST_ID, ITEM_TYPE ITEM_TYPE, REQ_TEMPLATE_PO_LINE_ID REQ_TEMPLATE_PO_LINE_ID, ITEM_REVISION ITEM_REVISION, PO_HEADER_ID PO_HEADER_ID, DOCUMENT_NUMBER DOCUMENT_NUMBER, LINE_NUM LINE_NUM, ALLOW_PRICE_OVERRIDE_FLAG ALLOW_PRICE_OVERRIDE_FLAG, NOT_TO_EXCEED_PRICE NOT_TO_EXCEED_PRICE, LINE_TYPE_ID LINE_TYPE_ID, UNIT_MEAS_LOOKUP_CODE UNIT_MEAS_LOOKUP_CODE, SUGGESTED_QUANTITY SUGGESTED_QUANTITY, UNIT_PRICE UNIT_PRICE, AMOUNT AMOUNT, CURRENCY_CODE CURRENCY_CODE, RATE_TYPE RATE_TYPE, RATE_DATE RATE_DATE, RATE RATE, BUYER_ID BUYER_ID, SUPPLIER_CONTACT_ID SUPPLIER_CONTACT_ID, RFQ_REQUIRED_FLAG RFQ_REQUIRED_FLAG, NEGOTIATED_BY_PREPARER_FLAG NEGOTIATED_BY_PREPARER_FLAG, DESCRIPTION DESCRIPTION, ORDER_TYPE_LOOKUP_CODE ORDER_TYPE_LOOKUP_CODE, SUPPLIER SUPPLIER, GLOBAL_AGREEMENT_FLAG GLOBAL_AGREEMENT_FLAG, MERGED_SOURCE_TYPE MERGED_SOURCE_TYPE from "ICX"."ICX_CAT_ITEMS_CTX_HDRS_TLP"

View Text - HTML Formatted

SELECT INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, PO_LINE_ID PO_LINE_ID
, REQ_TEMPLATE_NAME REQ_TEMPLATE_NAME
, REQ_TEMPLATE_LINE_NUM REQ_TEMPLATE_LINE_NUM
, ORG_ID ORG_ID
, LANGUAGE LANGUAGE
, SOURCE_TYPE SOURCE_TYPE
, PURCHASING_ORG_ID PURCHASING_ORG_ID
, IP_CATEGORY_ID IP_CATEGORY_ID
, IP_CATEGORY_NAME IP_CATEGORY_NAME
, PO_CATEGORY_ID PO_CATEGORY_ID
, OWNING_ORG_ID OWNING_ORG_ID
, CTX_DESC CTX_DESC
, SUPPLIER_ID SUPPLIER_ID
, SUPPLIER_PART_NUM SUPPLIER_PART_NUM
, SUPPLIER_PART_AUXID SUPPLIER_PART_AUXID
, SUPPLIER_SITE_ID SUPPLIER_SITE_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_LOGIN_ID PROGRAM_LOGIN_ID
, INTERNAL_REQUEST_ID INTERNAL_REQUEST_ID
, ITEM_TYPE ITEM_TYPE
, REQ_TEMPLATE_PO_LINE_ID REQ_TEMPLATE_PO_LINE_ID
, ITEM_REVISION ITEM_REVISION
, PO_HEADER_ID PO_HEADER_ID
, DOCUMENT_NUMBER DOCUMENT_NUMBER
, LINE_NUM LINE_NUM
, ALLOW_PRICE_OVERRIDE_FLAG ALLOW_PRICE_OVERRIDE_FLAG
, NOT_TO_EXCEED_PRICE NOT_TO_EXCEED_PRICE
, LINE_TYPE_ID LINE_TYPE_ID
, UNIT_MEAS_LOOKUP_CODE UNIT_MEAS_LOOKUP_CODE
, SUGGESTED_QUANTITY SUGGESTED_QUANTITY
, UNIT_PRICE UNIT_PRICE
, AMOUNT AMOUNT
, CURRENCY_CODE CURRENCY_CODE
, RATE_TYPE RATE_TYPE
, RATE_DATE RATE_DATE
, RATE RATE
, BUYER_ID BUYER_ID
, SUPPLIER_CONTACT_ID SUPPLIER_CONTACT_ID
, RFQ_REQUIRED_FLAG RFQ_REQUIRED_FLAG
, NEGOTIATED_BY_PREPARER_FLAG NEGOTIATED_BY_PREPARER_FLAG
, DESCRIPTION DESCRIPTION
, ORDER_TYPE_LOOKUP_CODE ORDER_TYPE_LOOKUP_CODE
, SUPPLIER SUPPLIER
, GLOBAL_AGREEMENT_FLAG GLOBAL_AGREEMENT_FLAG
, MERGED_SOURCE_TYPE MERGED_SOURCE_TYPE
FROM "ICX"."ICX_CAT_ITEMS_CTX_HDRS_TLP"