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_PRICE_LISTS

Object Details

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

Stores price lists information. There is 1 price list per buyer/supplier combination. Also, a price list supports a single currency. There are 2 types of price lists: marketplace price lists which contain prices for the entire buying community and buyer specific prices which contain prices specific to a buyer.

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ICX_POR_PRICE_LISTS_N1	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	SUPPLIER_ID NAME STATUS
ICX_POR_PRICE_LISTS_N2	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	BUYER_ID STATUS SUPPLIER_ID
ICX_POR_PRICE_LISTS_N4	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	PARENT_HEADER_ID

Columns

Name	Datatype	Length	Mandatory	Comments
HEADER_ID	NUMBER		Yes	Price List unique identifier.
NAME	VARCHAR2	(250)	Yes	Price List Name
SUPPLIER_ID	NUMBER		Yes	Supplier ID for supplier providing the Price List.
BUYER_ID	NUMBER		Yes	Buyer ID which can either be the Operator ID if Price List is for all buyers or a specific buyer for buyer specific Price List.
DESCRIPTION	VARCHAR2	(2000)		Description
CURRENCY_CODE	VARCHAR2	(4)	Yes	Currency Code
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
JOB_NUMBER	NUMBER			Job Number
BEGINDATE	DATE			Begin date
ENDDATE	DATE			End date
STATUS	VARCHAR2	(30)		Status
PUBLISHED_DATE	DATE			Date published
OUTDATED_DATE	DATE			Date outdated
APPROVAL_DATE	DATE			Date of approval
REJECTED_DATE	DATE			Date rejected
DELETED_DATE	DATE			Date deleted
BUYERCOMMENTS	VARCHAR2	(2000)		Comments from buyer
ACTION	VARCHAR2	(30)		Action
TYPE	VARCHAR2	(1)		Type
PARENT_HEADER_ID	NUMBER			Parent header id
CONTRACT_NUMBER	VARCHAR2	(20)		Contract Number

Query Text

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


SELECT HEADER_ID
,      NAME
,      SUPPLIER_ID
,      BUYER_ID
,      DESCRIPTION
,      CURRENCY_CODE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      JOB_NUMBER
,      BEGINDATE
,      ENDDATE
,      STATUS
,      PUBLISHED_DATE
,      OUTDATED_DATE
,      APPROVAL_DATE
,      REJECTED_DATE
,      DELETED_DATE
,      BUYERCOMMENTS
,      ACTION
,      TYPE
,      PARENT_HEADER_ID
,      CONTRACT_NUMBER
FROM ICX.ICX_POR_PRICE_LISTS;

Dependencies

[top of page]

ICX.ICX_POR_PRICE_LISTS does not reference any database object

ICX.ICX_POR_PRICE_LISTS is referenced by following:

ICX: ICX_POR_PRICE_LISTS#