[Home] [Help] [Dependency Information]

VIEW: ICX.POR_NONCAT_TEMPLATES_ALL_B#

Object Details

[View Source]

Columns

Query Text

Cut, paste (and edit) the following text to query this object:

SELECT TEMPLATE_ID
,      ORG_ID
,      ITEM_TYPE
,      DESC_EDITABLE_FLAG
,      CATEGORY_ID
,      CAT_EDITABLE_FLAG
,      RESTRICT_CATEGORY_FLAG
,      COMMODITY_ID
,      QUANTITY
,      UNIT_OF_MEASURE_CODE
,      UOM_EDITABLE_FLAG
,      UNIT_PRICE
,      PRICE_EDITABLE_FLAG
,      AMOUNT
,      AMOUNT_EDITABLE_FLAG
,      CURRENCY_CODE
,      CURRENCY_EDITABLE_FLAG
,      RATE
,      RATE_EDITABLE_FLAG
,      RATE_TYPE
,      RATE_TYPE_EDITABLE_FLAG
,      RATE_DATE
,      RATE_DATE_EDITABLE_FLAG
,      CONTRACT_ID
,      CONTRACT_EDITABLE_FLAG
,      NEW_SUPPLIER_FLAG
,      SUPPLIER_ID
,      SUPPLIER_EDITABLE_FLAG
,      RESTRICT_SUPPLIER_TYPE
,      SUPPLIER_SITE_ID
,      SITE_EDITABLE_FLAG
,      SUPPLIER_CONTACT_ID
,      CONTACT_EDITABLE_FLAG
,      SUPPLIER_CONTACT_PHONE
,      PHONE_EDITABLE_FLAG
,      SUPPLIER_CONTACT_FAX
,      FAX_EDITABLE_FLAG
,      SUPPLIER_CONTACT_EMAIL
,      EMAIL_EDITABLE_FLAG
,      SUPPLIER_ITEM
,      SUPPLIER_ITEM_EDITABLE_FLAG
,      MANUFACTURER
,      MANUFACTURER_EDITABLE_FLAG
,      MANUFACTURER_PART_NUMBER
,      MPN_EDITABLE_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      NEGOTIATED_BY_PREPARER_FLAG
,      NEGOTIATED_EDITABLE_FLAG
,      NEW_RESPONSIBILITIES_FLAG
,      RFQ_REQUIRED_FLAG
,      RFQ_REQ_EDITABLE_FLAG
,      CONTRACT_TYPE
,      COST_CONSTRAINT
,      ZD_EDITION_NAME
FROM ICX.POR_NONCAT_TEMPLATES_ALL_B#;

Dependencies

[top of page]

ICX

POR_NONCAT_TEMPLATES_ALL_B

APPS

POR_NONCAT_TEMPLATES_ALL_B

POR_NONCAT_TEMPLATES_ALL_B+