eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: ICX.POR_NONCAT_TEMPLATES_ALL_B

Object Details

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.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
POR_NONCAT_TEMPLATES_ALL_B_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	TEMPLATE_ID ZD_EDITION_NAME

Columns

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 deprecated
RFQ_REQUIRED_FLAG	VARCHAR2	(1)	Yes	RFQ required flag
RFQ_REQ_EDITABLE_FLAG	VARCHAR2	(1)	Yes	RFQ requisition editable flag
CONTRACT_TYPE	VARCHAR2	(100)		Contract Type for Complex Pricing
COST_CONSTRAINT	VARCHAR2	(100)		Cost Constraint for Complex Pricing
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

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 does not reference any database object

ICX.POR_NONCAT_TEMPLATES_ALL_B is referenced by following:

ICX: POR_NONCAT_TEMPLATES_ALL_B#