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_ITEMS_CTX_HDRS_TLP

Object Details

Object Name:	ICX_CAT_ITEMS_CTX_HDRS_TLP
Object Type:	TABLE
Owner:	ICX
Subobject Name:
Status:	VALID

This table holds the ids of blankets(local/global), quotations, requisition templates, and inventory items that are valid to be shown in iProcurement search.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: ICX_CAT_ITEMS_CTX_HDRS_TLP_PK

PO_LINE_ID
INVENTORY_ITEM_ID
REQ_TEMPLATE_NAME
REQ_TEMPLATE_LINE_NUM
ORG_ID
LANGUAGE

Indexes

Index	Type	Uniqueness	Tablespace	Column
ICX_CAT_ITEMS_CTX_HDRS_TLP_PK	NORMAL	UNIQUE	APPS_TS_TX_DATA	PO_LINE_ID INVENTORY_ITEM_ID REQ_TEMPLATE_NAME REQ_TEMPLATE_LINE_NUM ORG_ID LANGUAGE
ICX_CAT_ITEMSCTXDESC_HDRS	DOMAIN	NONUNIQUE		CTX_DESC
ICX_CAT_ITEMS_CTX_HDRS_TLP_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INVENTORY_ITEM_ID ORG_ID SUPPLIER_ID SUPPLIER_PART_NUM SUPPLIER_PART_AUXID
ICX_CAT_ITEMS_CTX_HDRS_TLP_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INTERNAL_REQUEST_ID
ICX_CAT_ITEMS_CTX_HDRS_TLP_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	IP_CATEGORY_ID

Columns

Name	Datatype	Length	Mandatory	Comments
INVENTORY_ITEM_ID	NUMBER		Yes	Inventory Item Id
PO_LINE_ID	NUMBER		Yes	PO Line Id
REQ_TEMPLATE_NAME	VARCHAR2	(25)	Yes	Express name from requisition template
REQ_TEMPLATE_LINE_NUM	NUMBER		Yes	Sequence num from requisition template
ORG_ID	NUMBER		Yes	Org Id
LANGUAGE	VARCHAR2	(4)	Yes	Language
SOURCE_TYPE	VARCHAR2	(20)	Yes	Indicates the source of the item. The possible values: 1. BLANKET 2. GLOBAL_BLANKET 3. QUOTATION 4. TEMPLATE 5. INTERNAL_TEMPLATE 6. MASTER_ITEM
PURCHASING_ORG_ID	NUMBER		Yes	Purchasing org id, used specifically for Supplier Item Catalog. For 'GLOBAL_BLANKET' lines, the value will be populated from po_ga_org_assignments.purchasing_org_id. For rest of the lines, this will be populated the same as org id
IP_CATEGORY_ID	NUMBER			Rt Category Id to which the item belongs to
IP_CATEGORY_NAME	VARCHAR2	(250)		Category Name to which the item belongs to
PO_CATEGORY_ID	NUMBER			PO Category Id to which the item belongs to
OWNING_ORG_ID	NUMBER			Owning org id of the item, will be different for the items with source_type='GLOBAL_BLANKET'. This one is the owning_org_id of the global blanket lines.
CTX_DESC	VARCHAR2	(1)		Oracle Text Indexed column, defined using multi-lexer
SUPPLIER_ID	NUMBER			Supplier Id
SUPPLIER_PART_NUM	VARCHAR2	(700)		Supplier part num
SUPPLIER_PART_AUXID	VARCHAR2	(255)		Supplier part auxiliary id
SUPPLIER_SITE_ID	NUMBER			Supplier site id
LAST_UPDATE_LOGIN	NUMBER			Standard WHO Column
LAST_UPDATED_BY	NUMBER		Yes	Standard WHO Column
LAST_UPDATE_DATE	DATE		Yes	Standard WHO Column
CREATED_BY	NUMBER		Yes	Standard WHO Column
CREATION_DATE	DATE		Yes	Standard WHO Column
REQUEST_ID	NUMBER			Standard Concurrent Request Column: Identifies the concurrent request instance that spawned the concurrent program
PROGRAM_APPLICATION_ID	NUMBER			Standard Concurrent Request Column: Identifies the Oracle Application that spawned the concurrent program
PROGRAM_ID	NUMBER			Standard Concurrent Request Column: Identifies the concurrent program
PROGRAM_LOGIN_ID	NUMBER			Standard Concurrent Request Column: Identifies the Oracle Applications Concurrent Program Login ID
INTERNAL_REQUEST_ID	NUMBER			Internal_request_id to track the changes done in a job. Different from request_id, because source of the items may not always be concurrent jobs.
ITEM_TYPE	VARCHAR2	(8)		Item type of the item. The possible values: 1. PURCHASE (Blanket, global_blanket, quotation, requisition template lines and purchasing enabled master items). 2. INTERNAL (Internal requisition template lines and internal order enabled master items). 3. BOTH (Master items that are purchasing and internal order enabled).
REQ_TEMPLATE_PO_LINE_ID	NUMBER			Source document line unique identifier
ITEM_REVISION	VARCHAR2	(3)		Item revision
PO_HEADER_ID	NUMBER			PO header id
DOCUMENT_NUMBER	VARCHAR2	(20)		Document number
LINE_NUM	NUMBER			Line number
ALLOW_PRICE_OVERRIDE_FLAG	VARCHAR2	(1)		Indicates whether the price can be changed
NOT_TO_EXCEED_PRICE	NUMBER			Price limit that cannot be exceeded
LINE_TYPE_ID	NUMBER			Line type id
UNIT_MEAS_LOOKUP_CODE	VARCHAR2	(25)		Unit of measure
SUGGESTED_QUANTITY	NUMBER			Suggested quantity on a requisition template
UNIT_PRICE	NUMBER			Unit price
AMOUNT	NUMBER			Amount
CURRENCY_CODE	VARCHAR2	(15)		Currency code
RATE_TYPE	VARCHAR2	(30)		Rate type
RATE_DATE	DATE			Rate date
RATE	NUMBER			Rate
BUYER_ID	NUMBER			Buyer id
SUPPLIER_CONTACT_ID	NUMBER			Supplier contact id
RFQ_REQUIRED_FLAG	VARCHAR2	(1)		Rfq required flag
NEGOTIATED_BY_PREPARER_FLAG	VARCHAR2	(1)		Negotiated by preparer flag
DESCRIPTION	VARCHAR2	(240)		Description
ORDER_TYPE_LOOKUP_CODE	VARCHAR2	(25)		Order type lookup code
SUPPLIER	VARCHAR2	(240)		Supplier
GLOBAL_AGREEMENT_FLAG	VARCHAR2	(1)		Global agreement flag
MERGED_SOURCE_TYPE	VARCHAR2	(15)		Source type

Query Text

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


SELECT INVENTORY_ITEM_ID
,      PO_LINE_ID
,      REQ_TEMPLATE_NAME
,      REQ_TEMPLATE_LINE_NUM
,      ORG_ID
,      LANGUAGE
,      SOURCE_TYPE
,      PURCHASING_ORG_ID
,      IP_CATEGORY_ID
,      IP_CATEGORY_NAME
,      PO_CATEGORY_ID
,      OWNING_ORG_ID
,      CTX_DESC
,      SUPPLIER_ID
,      SUPPLIER_PART_NUM
,      SUPPLIER_PART_AUXID
,      SUPPLIER_SITE_ID
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      CREATED_BY
,      CREATION_DATE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_LOGIN_ID
,      INTERNAL_REQUEST_ID
,      ITEM_TYPE
,      REQ_TEMPLATE_PO_LINE_ID
,      ITEM_REVISION
,      PO_HEADER_ID
,      DOCUMENT_NUMBER
,      LINE_NUM
,      ALLOW_PRICE_OVERRIDE_FLAG
,      NOT_TO_EXCEED_PRICE
,      LINE_TYPE_ID
,      UNIT_MEAS_LOOKUP_CODE
,      SUGGESTED_QUANTITY
,      UNIT_PRICE
,      AMOUNT
,      CURRENCY_CODE
,      RATE_TYPE
,      RATE_DATE
,      RATE
,      BUYER_ID
,      SUPPLIER_CONTACT_ID
,      RFQ_REQUIRED_FLAG
,      NEGOTIATED_BY_PREPARER_FLAG
,      DESCRIPTION
,      ORDER_TYPE_LOOKUP_CODE
,      SUPPLIER
,      GLOBAL_AGREEMENT_FLAG
,      MERGED_SOURCE_TYPE
FROM ICX.ICX_CAT_ITEMS_CTX_HDRS_TLP;

Dependencies

[top of page]

ICX.ICX_CAT_ITEMS_CTX_HDRS_TLP does not reference any database object

ICX.ICX_CAT_ITEMS_CTX_HDRS_TLP is referenced by following:

APPS: ICX_CAT_ITEMS_CTX_HDRS_TLP