[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | POR_NONCAT_TEMPLATES_ALL_VL |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| Subobject Name: | |
| Status: | VALID |
MultiLingual view (a language resolved view of the data.)
This view stores non-catalog request template information.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ROW_ID | ROWID | (10) | row ID | |
| 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 | |
| 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 | |
| RFQ_REQUIRED_FLAG | VARCHAR2 | (1) | Yes | RFQ required flag |
| RFQ_REQ_EDITABLE_FLAG | VARCHAR2 | (1) | Yes | RFQ requisition editable flag |
| NEW_RESPONSIBILITIES_FLAG | VARCHAR2 | (1) | Obsolete | |
| TEMPLATE_NAME | VARCHAR2 | (240) | non-catalog template name | |
| ITEM_DESCRIPTION | VARCHAR2 | (240) | item description | |
| IMAGE | VARCHAR2 | (2000) | image | |
| KEYWORDS | VARCHAR2 | (4000) | used by search results to display non-catalog template when there is a keyword match | |
| 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 | ||
| CONTRACT_TYPE | VARCHAR2 | (100) | Contract Type for Complex Pricing | |
| COST_CONSTRAINT | VARCHAR2 | (100) | Cost Constraint for Complex Pricing |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, 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
, NEGOTIATED_BY_PREPARER_FLAG
, NEGOTIATED_EDITABLE_FLAG
, RFQ_REQUIRED_FLAG
, RFQ_REQ_EDITABLE_FLAG
, NEW_RESPONSIBILITIES_FLAG
, TEMPLATE_NAME
, ITEM_DESCRIPTION
, IMAGE
, KEYWORDS
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, CONTRACT_TYPE
, COST_CONSTRAINT
FROM APPS.POR_NONCAT_TEMPLATES_ALL_VL;
APPS
POR_NONCAT_TEMPLATES_ALL_B
POR_NONCAT_TEMPLATES_ALL_TL
APPS.POR_NONCAT_TEMPLATES_ALL_VL is not referenced by any database object
|
|
|
|