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.ICX_CAT_ITEM_PRICES

Object Details

Object Name:	ICX_CAT_ITEM_PRICES
Object Type:	TABLE
Owner:	ICX
FND Design Data:	ICX.ICX_CAT_ITEM_PRICES
Subobject Name:
Status:	VALID

This table is obsolete since R12.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ICX_CAT_ITEM_PRICES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RT_ITEM_ID ACTIVE_FLAG ORG_ID
ICX_CAT_ITEM_PRICES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PRICE_LIST_ID RT_ITEM_ID ORG_ID SUPPLIER_SITE_ID
ICX_CAT_ITEM_PRICES_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TEMPLATE_ID TEMPLATE_LINE_ID ORG_ID
ICX_CAT_ITEM_PRICES_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CONTRACT_ID CONTRACT_LINE_ID ORG_ID
ICX_CAT_ITEM_PRICES_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ASL_ID ORG_ID
ICX_CAT_ITEM_PRICES_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INVENTORY_ITEM_ID ORG_ID
ICX_CAT_ITEM_PRICES_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LOCAL_RT_ITEM_ID PRICE_TYPE
ICX_CAT_ITEM_PRICES_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CONTRACT_ID SUPPLIER_SITE_ID PRICE_TYPE CURRENCY

Columns

Name	Datatype	Length	Mandatory	Comments
RT_ITEM_ID	NUMBER		Yes	Internally generated Item Id. (References ICX_CAT_ITEMS_B.rt_item_id)
PRICE_TYPE	VARCHAR2	(20)		Type of the price line. Possible values are -BLANKET, ASL, TEMPLATE, BULKLOAD etc.
ACTIVE_FLAG	VARCHAR2	(1)		Flag Attribute Indication if a price is active or not.
OBJECT_VERSION_NUMBER	NUMBER		Yes	Object version number. Set to 1 initially, incremented every time the row is updated
ASL_ID	NUMBER			The Approved Supplier List Id. Populated with the ASL ID for price rows of type of ASL, defaulted with -2 for other price rows.
SUPPLIER_SITE_ID	NUMBER			Vendor site id (References po_vendor_sites_all.vendor_site_id). Defaulted with the value -2.
CONTRACT_ID	NUMBER			Blanket/Contract/Global Agreement Id. (References PO_HEADERS_ALL.po_header_id) Populated with the PO_HEADER_ID for price rows of type of BLANKET/CONTRACT/GLOBAL AGREEMENT, defaulted with -2 for other price rows.
CONTRACT_LINE_ID	NUMBER			Blanket/Contract/Global agreement line number. (References PO_LINES_ALL.po_line_id). Populated with the PO_LINE_ID for price rows of type of BLANKET/GLOBAL AGREEMENT, defaulted with -2 for other price rows.
TEMPLATE_ID	VARCHAR2	(25)		Requisition Template Name. (References PO_REQEXPRESS_HEADERS_ALL.express_name) Populated with the POR_REQEXPRESS_NAME for price rows of type of TEMPLATE, defaulted with -2 for other price rows.
TEMPLATE_LINE_ID	NUMBER			Sequence Number of the Requisition Template Line. (References PO_REQEXPRESS_LINES_ALL.sequence_num) Populated with the SEQUENCE_NUM for price rows of type of TEMPLATE, defaulted with -2 for other price rows.
INVENTORY_ITEM_ID	NUMBER			Item unique identifier. (References MTL_SYSTEM_ITEMS_B.inventory_item_id.). Populated with the INVENTORY_ITEM_ID for price rows of type of INTERNAL_ITEM/ PURCHASING_ITEM, defaulted with -2 for other price rows
MTL_CATEGORY_ID	NUMBER			Item category unique identifier. (References MTL_CATEGORIES_B.category_id.) Defaulted with the value -2 for price rows of type CONTRACT/BULKLOAD
ORG_ID	NUMBER			Operating Unit Id, to which the item belongs. A value of '-2' indicates that the item will be available for All Operating Units.
SEARCH_TYPE	VARCHAR2	(8)		Internal or Supplier sourced item. Thus probable values are 'SUPPLIER' or 'INTERNAL'.
UNIT_PRICE	NUMBER			Unit price of the Item.
CURRENCY	VARCHAR2	(15)		Transactional Currency
UNIT_OF_MEASURE	VARCHAR2	(3)		Unit of measure for the Item. (References MTL_UNITS_OF_MEASURE.unit_of_measure.)
FUNCTIONAL_PRICE	NUMBER			Functional price of the Item. Calculated as per the Rate (derived for the Rate Type, Functional currency of the Operating Unit and the Transactional Currency) and the Unit Price.
SUPPLIER_SITE_CODE	VARCHAR2	(100)		Vendor Site Code (References PO_VENDOR_SITES_ALL.VENDOR_SITE_CODE)
CONTRACT_NUM	VARCHAR2	(20)		Contract number referenced by the price row. (References the PO_HEADERS_ALL .SEGMENT1)
CONTRACT_LINE_NUM	NUMBER			Sequence Number of the Contract Line referenced by the price row. (References the PO_LINES_ALL.LINE_NUM)
PRICE_LIST_ID	NUMBER			The Price List Header Id for the price row. (References ICX_CAT_ITEM_PRICLISTS. PRICE LIST ID) Populated if this price is bulk loaded.
SUPPLIER_NUMBER	VARCHAR2	(30)		Supplier Number, for favorite list
SUPPLIER_CONTACT_ID	NUMBER			Supplier Contact ID, for favorite list
ITEM_REVISION	VARCHAR2	(3)		Item Revision, for favorite list
LINE_TYPE_ID	NUMBER			Line Type, for favorite list
BUYER_ID	NUMBER			Buyer ID, for favorite list
RATE_TYPE	VARCHAR2	(30)		Rate type
RATE_DATE	DATE			Rate Date.
RATE	NUMBER			Rate
LOCAL_RT_ITEM_ID	NUMBER			The Global Blanket Agreement's Owning Organization Item Id. (References ICX_CAT_ITEM_B.RT_ITEM_ID)
LAST_UPDATE_LOGIN	NUMBER			Standard Who column: identifies sign-on audit information of the user who last updated this record. (References FND_LOGINS.login_id.)
LAST_UPDATED_BY	NUMBER			Standard Who column: the user who last updated this record. (References FND_USERS.user_id.)
LAST_UPDATE_DATE	DATE			Standard Who column: date when this record was last updated
CREATED_BY	NUMBER			Standard Who column: the user who created this record. (References FND_USERS.user_id.)
CREATION_DATE	DATE			Standard Who column: date when this record was created
REQUEST_ID	NUMBER			Concurrent Request Id through which items are extracted/bulkloaded.
PROGRAM_APPLICATION_ID	NUMBER			Standard Who column: the application that owns the concurrent program that created or updated this record. (References FND_CONCURRENT_PROGRAMS.application_id.)
PROGRAM_ID	NUMBER			Standard Who column: the concurrent program that created or updated this record. (References FND_CONCURRENT_PROGRAMS.concurrent_program_id.)
PROGRAM_UPDATE_DATE	DATE			Standard Who column: the date when this record was created or updated by a concurrent program
SUGGESTED_QUANTITY	NUMBER			Specifies the Suggested Quantity for the Requestor.
ALLOW_PRICE_OVERRIDE_FLAG	VARCHAR2	(1)		Stores 'Y' or 'N'.
NOT_TO_EXCEED_PRICE	NUMBER			Specifies the upper limit for the price.
VALUE_BASIS	VARCHAR2	(25)		Specifies the pricing characteristics of the Purchase.. Probable values 'AMOUNT'/ 'FIXED PRICE'/ 'QUANTITY'/'PRICE'
PURCHASE_BASIS	VARCHAR2	(30)		Specifies the nature of the purchase.. Possible values are 'GOODS'/ 'SERVICES'/'TEMP LABOR'
NEGOTIATED_BY_PREPARER_FLAG	VARCHAR2	(1)		Specifies whether the price is negotiated or not. Stores 'Y'/'N'.

Query Text

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


SELECT RT_ITEM_ID
,      PRICE_TYPE
,      ACTIVE_FLAG
,      OBJECT_VERSION_NUMBER
,      ASL_ID
,      SUPPLIER_SITE_ID
,      CONTRACT_ID
,      CONTRACT_LINE_ID
,      TEMPLATE_ID
,      TEMPLATE_LINE_ID
,      INVENTORY_ITEM_ID
,      MTL_CATEGORY_ID
,      ORG_ID
,      SEARCH_TYPE
,      UNIT_PRICE
,      CURRENCY
,      UNIT_OF_MEASURE
,      FUNCTIONAL_PRICE
,      SUPPLIER_SITE_CODE
,      CONTRACT_NUM
,      CONTRACT_LINE_NUM
,      PRICE_LIST_ID
,      SUPPLIER_NUMBER
,      SUPPLIER_CONTACT_ID
,      ITEM_REVISION
,      LINE_TYPE_ID
,      BUYER_ID
,      RATE_TYPE
,      RATE_DATE
,      RATE
,      LOCAL_RT_ITEM_ID
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      CREATED_BY
,      CREATION_DATE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      SUGGESTED_QUANTITY
,      ALLOW_PRICE_OVERRIDE_FLAG
,      NOT_TO_EXCEED_PRICE
,      VALUE_BASIS
,      PURCHASE_BASIS
,      NEGOTIATED_BY_PREPARER_FLAG
FROM ICX.ICX_CAT_ITEM_PRICES;

Dependencies

[top of page]

ICX.ICX_CAT_ITEM_PRICES does not reference any database object

ICX.ICX_CAT_ITEM_PRICES is referenced by following:

APPS: ICX_CAT_ITEM_PRICES