[Home] [Help] [Dependency Information]
Object Name: | POR_NONCAT_TEMPLATES_ALL_B# |
---|---|
Object Type: | VIEW |
Owner: | ICX |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TEMPLATE_ID | NUMBER | Yes | ||
ORG_ID | NUMBER | |||
ITEM_TYPE | VARCHAR2 | (30) | ||
DESC_EDITABLE_FLAG | VARCHAR2 | (1) | ||
CATEGORY_ID | NUMBER | |||
CAT_EDITABLE_FLAG | VARCHAR2 | (1) | ||
RESTRICT_CATEGORY_FLAG | VARCHAR2 | (1) | ||
COMMODITY_ID | NUMBER | |||
QUANTITY | NUMBER | |||
UNIT_OF_MEASURE_CODE | VARCHAR2 | (25) | ||
UOM_EDITABLE_FLAG | VARCHAR2 | (1) | ||
UNIT_PRICE | NUMBER | |||
PRICE_EDITABLE_FLAG | VARCHAR2 | (1) | ||
AMOUNT | NUMBER | |||
AMOUNT_EDITABLE_FLAG | VARCHAR2 | (1) | ||
CURRENCY_CODE | VARCHAR2 | (15) | ||
CURRENCY_EDITABLE_FLAG | VARCHAR2 | (1) | ||
RATE | NUMBER | |||
RATE_EDITABLE_FLAG | VARCHAR2 | (1) | ||
RATE_TYPE | VARCHAR2 | (30) | ||
RATE_TYPE_EDITABLE_FLAG | VARCHAR2 | (1) | ||
RATE_DATE | DATE | |||
RATE_DATE_EDITABLE_FLAG | VARCHAR2 | (1) | ||
CONTRACT_ID | NUMBER | |||
CONTRACT_EDITABLE_FLAG | VARCHAR2 | (1) | ||
NEW_SUPPLIER_FLAG | VARCHAR2 | (1) | ||
SUPPLIER_ID | NUMBER | |||
SUPPLIER_EDITABLE_FLAG | VARCHAR2 | (1) | ||
RESTRICT_SUPPLIER_TYPE | VARCHAR2 | (30) | ||
SUPPLIER_SITE_ID | NUMBER | |||
SITE_EDITABLE_FLAG | VARCHAR2 | (1) | ||
SUPPLIER_CONTACT_ID | NUMBER | |||
CONTACT_EDITABLE_FLAG | VARCHAR2 | (1) | ||
SUPPLIER_CONTACT_PHONE | VARCHAR2 | (25) | ||
PHONE_EDITABLE_FLAG | VARCHAR2 | (1) | ||
SUPPLIER_CONTACT_FAX | VARCHAR2 | (25) | ||
FAX_EDITABLE_FLAG | VARCHAR2 | (1) | ||
SUPPLIER_CONTACT_EMAIL | VARCHAR2 | (2000) | ||
EMAIL_EDITABLE_FLAG | VARCHAR2 | (1) | ||
SUPPLIER_ITEM | VARCHAR2 | (30) | ||
SUPPLIER_ITEM_EDITABLE_FLAG | VARCHAR2 | (1) | ||
MANUFACTURER | VARCHAR2 | (30) | ||
MANUFACTURER_EDITABLE_FLAG | VARCHAR2 | (1) | ||
MANUFACTURER_PART_NUMBER | VARCHAR2 | (30) | ||
MPN_EDITABLE_FLAG | VARCHAR2 | (1) | ||
CREATED_BY | NUMBER | Yes | ||
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | |||
NEGOTIATED_BY_PREPARER_FLAG | VARCHAR2 | (1) | ||
NEGOTIATED_EDITABLE_FLAG | VARCHAR2 | (1) | ||
NEW_RESPONSIBILITIES_FLAG | VARCHAR2 | (1) | ||
RFQ_REQUIRED_FLAG | VARCHAR2 | (1) | Yes | |
RFQ_REQ_EDITABLE_FLAG | VARCHAR2 | (1) | Yes | |
CONTRACT_TYPE | VARCHAR2 | (100) | ||
COST_CONSTRAINT | VARCHAR2 | (100) | ||
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
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#;
|
|
|