VIEW: ICX.POR_NONCAT_TEMPLATES_ALL_B#

Source

View Text - Preformatted

select TEMPLATE_ID TEMPLATE_ID, ORG_ID ORG_ID, ITEM_TYPE ITEM_TYPE, DESC_EDITABLE_FLAG DESC_EDITABLE_FLAG, CATEGORY_ID CATEGORY_ID, CAT_EDITABLE_FLAG CAT_EDITABLE_FLAG, RESTRICT_CATEGORY_FLAG RESTRICT_CATEGORY_FLAG, COMMODITY_ID COMMODITY_ID, QUANTITY QUANTITY, UNIT_OF_MEASURE_CODE UNIT_OF_MEASURE_CODE, UOM_EDITABLE_FLAG UOM_EDITABLE_FLAG, UNIT_PRICE UNIT_PRICE, PRICE_EDITABLE_FLAG PRICE_EDITABLE_FLAG, AMOUNT AMOUNT, AMOUNT_EDITABLE_FLAG AMOUNT_EDITABLE_FLAG, CURRENCY_CODE CURRENCY_CODE, CURRENCY_EDITABLE_FLAG CURRENCY_EDITABLE_FLAG, RATE RATE, RATE_EDITABLE_FLAG RATE_EDITABLE_FLAG, RATE_TYPE RATE_TYPE, RATE_TYPE_EDITABLE_FLAG RATE_TYPE_EDITABLE_FLAG, RATE_DATE RATE_DATE, RATE_DATE_EDITABLE_FLAG RATE_DATE_EDITABLE_FLAG, CONTRACT_ID CONTRACT_ID, CONTRACT_EDITABLE_FLAG CONTRACT_EDITABLE_FLAG, NEW_SUPPLIER_FLAG NEW_SUPPLIER_FLAG, SUPPLIER_ID SUPPLIER_ID, SUPPLIER_EDITABLE_FLAG SUPPLIER_EDITABLE_FLAG, RESTRICT_SUPPLIER_TYPE RESTRICT_SUPPLIER_TYPE, SUPPLIER_SITE_ID SUPPLIER_SITE_ID, SITE_EDITABLE_FLAG SITE_EDITABLE_FLAG, SUPPLIER_CONTACT_ID SUPPLIER_CONTACT_ID, CONTACT_EDITABLE_FLAG CONTACT_EDITABLE_FLAG, SUPPLIER_CONTACT_PHONE SUPPLIER_CONTACT_PHONE, PHONE_EDITABLE_FLAG PHONE_EDITABLE_FLAG, SUPPLIER_CONTACT_FAX SUPPLIER_CONTACT_FAX, FAX_EDITABLE_FLAG FAX_EDITABLE_FLAG, SUPPLIER_CONTACT_EMAIL SUPPLIER_CONTACT_EMAIL, EMAIL_EDITABLE_FLAG EMAIL_EDITABLE_FLAG, SUPPLIER_ITEM SUPPLIER_ITEM, SUPPLIER_ITEM_EDITABLE_FLAG SUPPLIER_ITEM_EDITABLE_FLAG, MANUFACTURER MANUFACTURER, MANUFACTURER_EDITABLE_FLAG MANUFACTURER_EDITABLE_FLAG, MANUFACTURER_PART_NUMBER MANUFACTURER_PART_NUMBER, MPN_EDITABLE_FLAG MPN_EDITABLE_FLAG, 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, NEGOTIATED_BY_PREPARER_FLAG NEGOTIATED_BY_PREPARER_FLAG, NEGOTIATED_EDITABLE_FLAG NEGOTIATED_EDITABLE_FLAG, NEW_RESPONSIBILITIES_FLAG NEW_RESPONSIBILITIES_FLAG, RFQ_REQUIRED_FLAG RFQ_REQUIRED_FLAG, RFQ_REQ_EDITABLE_FLAG RFQ_REQ_EDITABLE_FLAG, CONTRACT_TYPE CONTRACT_TYPE, COST_CONSTRAINT COST_CONSTRAINT, ZD_EDITION_NAME ZD_EDITION_NAME from "ICX"."POR_NONCAT_TEMPLATES_ALL_B"

View Text - HTML Formatted

SELECT TEMPLATE_ID TEMPLATE_ID
, ORG_ID ORG_ID
, ITEM_TYPE ITEM_TYPE
, DESC_EDITABLE_FLAG DESC_EDITABLE_FLAG
, CATEGORY_ID CATEGORY_ID
, CAT_EDITABLE_FLAG CAT_EDITABLE_FLAG
, RESTRICT_CATEGORY_FLAG RESTRICT_CATEGORY_FLAG
, COMMODITY_ID COMMODITY_ID
, QUANTITY QUANTITY
, UNIT_OF_MEASURE_CODE UNIT_OF_MEASURE_CODE
, UOM_EDITABLE_FLAG UOM_EDITABLE_FLAG
, UNIT_PRICE UNIT_PRICE
, PRICE_EDITABLE_FLAG PRICE_EDITABLE_FLAG
, AMOUNT AMOUNT
, AMOUNT_EDITABLE_FLAG AMOUNT_EDITABLE_FLAG
, CURRENCY_CODE CURRENCY_CODE
, CURRENCY_EDITABLE_FLAG CURRENCY_EDITABLE_FLAG
, RATE RATE
, RATE_EDITABLE_FLAG RATE_EDITABLE_FLAG
, RATE_TYPE RATE_TYPE
, RATE_TYPE_EDITABLE_FLAG RATE_TYPE_EDITABLE_FLAG
, RATE_DATE RATE_DATE
, RATE_DATE_EDITABLE_FLAG RATE_DATE_EDITABLE_FLAG
, CONTRACT_ID CONTRACT_ID
, CONTRACT_EDITABLE_FLAG CONTRACT_EDITABLE_FLAG
, NEW_SUPPLIER_FLAG NEW_SUPPLIER_FLAG
, SUPPLIER_ID SUPPLIER_ID
, SUPPLIER_EDITABLE_FLAG SUPPLIER_EDITABLE_FLAG
, RESTRICT_SUPPLIER_TYPE RESTRICT_SUPPLIER_TYPE
, SUPPLIER_SITE_ID SUPPLIER_SITE_ID
, SITE_EDITABLE_FLAG SITE_EDITABLE_FLAG
, SUPPLIER_CONTACT_ID SUPPLIER_CONTACT_ID
, CONTACT_EDITABLE_FLAG CONTACT_EDITABLE_FLAG
, SUPPLIER_CONTACT_PHONE SUPPLIER_CONTACT_PHONE
, PHONE_EDITABLE_FLAG PHONE_EDITABLE_FLAG
, SUPPLIER_CONTACT_FAX SUPPLIER_CONTACT_FAX
, FAX_EDITABLE_FLAG FAX_EDITABLE_FLAG
, SUPPLIER_CONTACT_EMAIL SUPPLIER_CONTACT_EMAIL
, EMAIL_EDITABLE_FLAG EMAIL_EDITABLE_FLAG
, SUPPLIER_ITEM SUPPLIER_ITEM
, SUPPLIER_ITEM_EDITABLE_FLAG SUPPLIER_ITEM_EDITABLE_FLAG
, MANUFACTURER MANUFACTURER
, MANUFACTURER_EDITABLE_FLAG MANUFACTURER_EDITABLE_FLAG
, MANUFACTURER_PART_NUMBER MANUFACTURER_PART_NUMBER
, MPN_EDITABLE_FLAG MPN_EDITABLE_FLAG
, 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
, NEGOTIATED_BY_PREPARER_FLAG NEGOTIATED_BY_PREPARER_FLAG
, NEGOTIATED_EDITABLE_FLAG NEGOTIATED_EDITABLE_FLAG
, NEW_RESPONSIBILITIES_FLAG NEW_RESPONSIBILITIES_FLAG
, RFQ_REQUIRED_FLAG RFQ_REQUIRED_FLAG
, RFQ_REQ_EDITABLE_FLAG RFQ_REQ_EDITABLE_FLAG
, CONTRACT_TYPE CONTRACT_TYPE
, COST_CONSTRAINT COST_CONSTRAINT
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "ICX"."POR_NONCAT_TEMPLATES_ALL_B"