[Home] [Help] [Dependency Information]
Object Name: | POR_NONCAT_TEMPLATES_ALL_B |
---|---|
Object Type: | TABLE |
Owner: | ICX |
Subobject Name: | |
Status: | VALID |
This table stores all the non-translatable attribute values for a non-catalog request template.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
POR_NONCAT_TEMPLATES_ALL_B_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | TEMPLATE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TEMPLATE_ID | NUMBER | Yes | Internally generated identifier for non-catalog request template | |
ORG_ID | NUMBER | The organization to which this non-catalog request template belongs | ||
ITEM_TYPE | VARCHAR2 | (30) | Item type of non-catalog request. The values can be GOODS (Goods billed by quantity), SERVICES (Services billed by quantity) or TOTAL_AMOUNT (Goods or services billed by amount) | |
DESC_EDITABLE_FLAG | VARCHAR2 | (1) | Flag to indicate whether 'Item Description' field is user-editable for a non-catalog request based on this template | |
CATEGORY_ID | NUMBER | The internal identifier of category with which the non-catalog request is associated | ||
CAT_EDITABLE_FLAG | VARCHAR2 | (1) | Flag to indicate whether 'Category' field is user-editable for a non-catalog request based on this template | |
RESTRICT_CATEGORY_FLAG | VARCHAR2 | (1) | Flag to indicate whether the selection of category is restricted by default commodity specified on this template | |
COMMODITY_ID | NUMBER | Internal identifier of commodity which is associated with selected category | ||
QUANTITY | NUMBER | Quantity of the item | ||
UNIT_OF_MEASURE_CODE | VARCHAR2 | (25) | Unit of measure code (not language-specific) | |
UOM_EDITABLE_FLAG | VARCHAR2 | (1) | Flag to indicate whether 'Unit of Measure' field is user-editable for a non-catalog request based on this template | |
UNIT_PRICE | NUMBER | Unit price of item in transactional currency | ||
PRICE_EDITABLE_FLAG | VARCHAR2 | (1) | Flag to indicate whether 'Unit Price' field is user-editable for a non-catalog request based on this template | |
AMOUNT | NUMBER | Total amount of item in transactional currency. It only applies when item type is 'Goods or services billed by amount' | ||
AMOUNT_EDITABLE_FLAG | VARCHAR2 | (1) | Flag to indicate whether 'Amount' field is user-editable for a non-catalog request based on this template | |
CURRENCY_CODE | VARCHAR2 | (15) | Transactional currency code | |
CURRENCY_EDITABLE_FLAG | VARCHAR2 | (1) | Flag to indicate whether 'Currency' field is user-editable for a non-catalog request based on this template | |
RATE | NUMBER | Conversion rate between transactional currency and functional currency | ||
RATE_EDITABLE_FLAG | VARCHAR2 | (1) | Flag to indicate whether 'Exchange Rate' field is user-editable for a non-catalog request based on this template | |
RATE_TYPE | VARCHAR2 | (30) | Exchange rate type between transactional currency and functional currency | |
RATE_TYPE_EDITABLE_FLAG | VARCHAR2 | (1) | Flag to indicate whether 'Exchange Rate Type' field is user-editable for a non-catalog request based on this template | |
RATE_DATE | DATE | Exchange rate date used in calculating rate | ||
RATE_DATE_EDITABLE_FLAG | VARCHAR2 | (1) | Flag to indicate whether 'Exchange Rate Date' field is user-editable for a non-catalog request based on this template | |
CONTRACT_ID | NUMBER | Internal identifier of contract associated with the non-catalog request. The contract can be both global and local | ||
CONTRACT_EDITABLE_FLAG | VARCHAR2 | (1) | Flag to indicate whether 'Contract Number' field is user-editable for a non-catalog request based on this template | |
NEW_SUPPLIER_FLAG | VARCHAR2 | (1) | Flag to indicate whether we need to validate against the supplier and site values entered | |
SUPPLIER_ID | NUMBER | Internal identifier of supplier. This is a foreign key to column vendor_id in po_vendors table | ||
SUPPLIER_EDITABLE_FLAG | VARCHAR2 | (1) | Flag to indicate whether 'Supplier' field is user-editable for a non-catalog request based on this template | |
RESTRICT_SUPPLIER_TYPE | VARCHAR2 | (30) | This value determines whether contract/supplier/site lovs will be restricted by the global suppliers defined in the category ASL. The values can be 'NO_RESTRICTION' or 'RESTRICT_CATEGORY_ASL' | |
SUPPLIER_SITE_ID | NUMBER | Internal identifier of site. This is a foreign key to column vendor_site_id in po_vendor_sites_all table | ||
SITE_EDITABLE_FLAG | VARCHAR2 | (1) | Flag to indicate whether 'Site' field is user-editable for a non-catalog request based on this template | |
SUPPLIER_CONTACT_ID | NUMBER | Internal identifier of supplier contact. This is a foreign key to column vendor_contact_id in po_vendor_contacts table | ||
CONTACT_EDITABLE_FLAG | VARCHAR2 | (1) | Flag to indicate whether 'Contact Name' field is user-editable for a non-catalog request based on this template | |
SUPPLIER_CONTACT_PHONE | VARCHAR2 | (25) | Phone number of supplier contact | |
PHONE_EDITABLE_FLAG | VARCHAR2 | (1) | Flag to indicate whether 'Phone' field is user-editable for a non-catalog request based on this template | |
SUPPLIER_CONTACT_FAX | VARCHAR2 | (25) | Fax number of supplier contact | |
FAX_EDITABLE_FLAG | VARCHAR2 | (1) | Flag to indicate whether 'Fax' field is user-editable for a non-catalog request based on this template | |
SUPPLIER_CONTACT_EMAIL | VARCHAR2 | (2000) | Email address of supplier contact | |
EMAIL_EDITABLE_FLAG | VARCHAR2 | (1) | Flag to indicate whether 'Email' field is user-editable for a non-catalog request based on this template | |
SUPPLIER_ITEM | VARCHAR2 | (30) | Supplier item number | |
SUPPLIER_ITEM_EDITABLE_FLAG | VARCHAR2 | (1) | Flag to indicate whether 'Supplier Item' field is user-editable for a non-catalog request based on this template | |
MANUFACTURER | VARCHAR2 | (30) | Manufacturer name | |
MANUFACTURER_EDITABLE_FLAG | VARCHAR2 | (1) | Flag to indicate whether 'Manufacturer' field is user-editable for a non-catalog request based on this template | |
MANUFACTURER_PART_NUMBER | VARCHAR2 | (30) | Manufacturer part number | |
MPN_EDITABLE_FLAG | VARCHAR2 | (1) | Flag to indicate whether 'Manufacturer Part Number' field is user-editable for a non-catalog request based on this template | |
CREATED_BY | NUMBER | Yes | Internal identifier of user who created the row | |
CREATION_DATE | DATE | Yes | Date on which row was created | |
LAST_UPDATED_BY | NUMBER | Yes | Internal identifier of user who last updated the row | |
LAST_UPDATE_DATE | DATE | Yes | Date on which row was last updated | |
LAST_UPDATE_LOGIN | NUMBER | Operating system login of user who last updated the row | ||
NEGOTIATED_BY_PREPARER_FLAG | VARCHAR2 | (1) | Flag to indicate whether the price is a negotiated price | |
NEGOTIATED_EDITABLE_FLAG | VARCHAR2 | (1) | Flag to indicate whether 'Negotiated' field is user-editable for a non-catalog request based on this template | |
NEW_RESPONSIBILITIES_FLAG | VARCHAR2 | (1) | Obsolete | |
RFQ_REQUIRED_FLAG | VARCHAR2 | (1) | Yes | RFQ required flag |
RFQ_REQ_EDITABLE_FLAG | VARCHAR2 | (1) | Yes | RFQ requisition editable flag |
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
FROM ICX.POR_NONCAT_TEMPLATES_ALL_B;
ICX.POR_NONCAT_TEMPLATES_ALL_B does not reference any database object
ICX.POR_NONCAT_TEMPLATES_ALL_B is referenced by following:
|
|
|