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_POR_CONTRACT_REFERENCES

Object Details

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

This table stores the Contract and Buyer information provided in the Contract Reference Section of an uploaded file. The Buyer and Contract information, specified in the Contract Reference section, is validated based on the contents of ICX_POR_CONTRACT_REFERENCES table. If it is an invalid reference, we store the Error Message to be displayed to user. For example, if the Buyer name given in the Contract Reference Section is invalid etc.
We store Buyer_Id = -1 when Buyer Name is null in the file in Contract section.
Upon successful validation, the other price attributes of the Contract Line are retrieved and stored in this table for Loader validation.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ICX_POR_CONTRACT_REFERENCES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	REQUEST_ID LINE_NUMBER

Columns

Name	Datatype	Length	Mandatory	Comments
JOB_NUMBER	NUMBER		Yes	Job Number. Concurrent Request Id through which items are Bulkloaded.
LINE_NUMBER	NUMBER		Yes	Line Number
BUYER_ID	NUMBER			Buyer Identifier. Operating Unit Id, to which the item belongs. We store the value -1 when Buyer Name is null in the Contract section of the uploaded data file.
BUYER_NAME	VARCHAR2	(240)		Buyer Name. This is the Operating Unit Name as specified in the loader file.
CONTRACT_REFERENCE_ID	NUMBER			Contract Purchase Agreement Id. (References PO_HEADERS_ALL.po_header_id).
CONTRACT_REFERENCE_NUM	VARCHAR2	(20)		Contract Purchase Agreement Number. (References PO_HEADERS_ALL.SEGMENT1)
SUPPLIER_ID	NUMBER			Supplier Id of the item.
SUPPLIER_SITE	VARCHAR2	(15)		Supplier Site Code
PRICELIST_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.
CURRENCY_CODE	VARCHAR2	(15)		Currency Code.
ERROR_MESSAGE	VARCHAR2	(2000)		Error Message for Contract line in loader file, in case of invalid Buyer/Contract reference.
REQUEST_ID	NUMBER		Yes	Concurrent Request Id through which items are extracted/bulkloaded.
SUPPLIER_SITE_ID	NUMBER			Supplier Site Id

Query Text

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


SELECT JOB_NUMBER
,      LINE_NUMBER
,      BUYER_ID
,      BUYER_NAME
,      CONTRACT_REFERENCE_ID
,      CONTRACT_REFERENCE_NUM
,      SUPPLIER_ID
,      SUPPLIER_SITE
,      PRICELIST_ID
,      CURRENCY_CODE
,      ERROR_MESSAGE
,      REQUEST_ID
,      SUPPLIER_SITE_ID
FROM ICX.ICX_POR_CONTRACT_REFERENCES;

Dependencies

[top of page]

ICX.ICX_POR_CONTRACT_REFERENCES does not reference any database object

ICX.ICX_POR_CONTRACT_REFERENCES is referenced by following:

APPS: ICX_POR_CONTRACT_REFERENCES