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_LIST_LINES

Object Details

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

Stores price list lines information. Not all price list lines are active and available for buyers, it depends on the buyer_approval_status flag. When a price line is first created it goes into a status of UNPUBLISHED. Once, the catalog author publishes the price line, then it either is automatically APPROVED if within all tolerances set forth by the buyer or it remains as PUBLISHED pending approval from the buyer.
For Marketplace price lines, there is no PUBLISHED state since the buyer (in this case the marketplace) is not allowed to set tolerances, instead, the line is automatically APPROVED.
Buyers can only shop for items with APPROVED pricing.
This table maintains audit trail information on price lines. Once a price line is APPROVED for an item, any existing APPROVED price line for the same item within the same price list is moved to OUTDATED state but it will remain in the table.

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ICX_POR_PRICE_LIST_LINES_N1	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	HEADER_ID BUYER_APPROVAL_STATUS ITEM_ID BEGINDATE
ICX_POR_PRICE_LIST_LINES_N2	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	SUPPLIER_ID
ICX_POR_PRICE_LIST_LINES_N3	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	BUYER_ID BUYER_APPROVAL_STATUS
ICX_POR_PRICE_LIST_LINES_N6	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	BUYER_APPROVAL_STATUS
ICX_POR_PRICE_LIST_LINES_N7	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	JOB_NUMBER BUYER_APPROVAL_STATUS
ICX_POR_PRICE_LIST_LINES_N8	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	EFFECTIVE_ENDDATE BUYER_APPROVAL_STATUS

Columns

Name	Datatype	Length	Mandatory	Comments
HEADER_ID	NUMBER		Yes	Price List ID
SUPPLIER_ID	NUMBER		Yes	Supplier ID
BUYER_ID	NUMBER		Yes	Buyer ID
ITEM_ID	NUMBER		Yes	Item ID
UNIT_PRICE	NUMBER			Price
UOM	VARCHAR2	(30)		Unit of Measure
CURRENCY_CODE	VARCHAR2	(4)	Yes	Currency Code
BUYER_APPROVAL_STATUS	VARCHAR2	(30)		Buyer Approval Status. Possible values are: APPROVED, DELETED, OUTDATED, PUBLISHED, UNPUBLISHED
BUYER_APPROVAL_DATE	DATE			Buyer Approval Date
INACTIVE_DATE	DATE			Inactive Date
DESCRIPTION	VARCHAR2	(2000)		Price Line Description
RATE	NUMBER			Not used
RATE_TYPE	VARCHAR2	(25)		Not used
RATE_DATE	DATE			Not used
BUYER_FUNCTIONAL_CURRENCY	VARCHAR2	(4)		Not used
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
SUPPLIER_SITE	VARCHAR2	(15)		Supplier site (IP only)
JOB_NUMBER	NUMBER			Job Number for batch job that generated the price line.
ACTION	VARCHAR2	(30)		Action on price such as ADD, UPDATE
PUBLISHED_DATE	DATE			Date price line was published
OUTDATED_DATE	DATE			Date price line was outdated
DELETED_DATE	DATE			Date price line was deleted
REJECTED_DATE	DATE			Date price line was rejected
COMMENTS	VARCHAR2	(2000)		Comments given by a buyer while rejecting a price line.
PRICE_CODE	VARCHAR2	(30)		price code used when no price available
SUPPLIERCOMMENTS	VARCHAR2	(2000)		Comments provided by the supplier on pricing
PRICE_BREAK_ID	NUMBER			Price Break identifier
PRICE_BREAK_COUNT	NUMBER			Number of Price Breaks associated with this line.
EFFECTIVE_BEGINDATE	DATE			Effective begin date of the price line. This depends on the begin date of the price list if begin date is inherited.
EFFECTIVE_ENDDATE	DATE			Effective end date of the price line. This depends on the end date of the price list if the end date of the price line is inherited.
BEGINDATE	DATE			Begin date of the price line.
ENDDATE	DATE			End date of the price line.
CONTRACT_REFERENCE_NUM	VARCHAR2	(20)		Contract Reference Number
CONTRACT_REFERENCE_ID	NUMBER			Contract Reference ID
PAYMENT_TERM	VARCHAR2	(30)		Payment Term
PRICE_FACTOR	VARCHAR2	(240)		Price Factor
DEFAULT_FLAG	VARCHAR2	(1)		Default Flag
OTHER_COMBINATIONS_FLAG	VARCHAR2	(1)		Other Combinations Flag

Query Text

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


SELECT HEADER_ID
,      SUPPLIER_ID
,      BUYER_ID
,      ITEM_ID
,      UNIT_PRICE
,      UOM
,      CURRENCY_CODE
,      BUYER_APPROVAL_STATUS
,      BUYER_APPROVAL_DATE
,      INACTIVE_DATE
,      DESCRIPTION
,      RATE
,      RATE_TYPE
,      RATE_DATE
,      BUYER_FUNCTIONAL_CURRENCY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      SUPPLIER_SITE
,      JOB_NUMBER
,      ACTION
,      PUBLISHED_DATE
,      OUTDATED_DATE
,      DELETED_DATE
,      REJECTED_DATE
,      COMMENTS
,      PRICE_CODE
,      SUPPLIERCOMMENTS
,      PRICE_BREAK_ID
,      PRICE_BREAK_COUNT
,      EFFECTIVE_BEGINDATE
,      EFFECTIVE_ENDDATE
,      BEGINDATE
,      ENDDATE
,      CONTRACT_REFERENCE_NUM
,      CONTRACT_REFERENCE_ID
,      PAYMENT_TERM
,      PRICE_FACTOR
,      DEFAULT_FLAG
,      OTHER_COMBINATIONS_FLAG
FROM ICX.ICX_POR_PRICE_LIST_LINES;

Dependencies

[top of page]

ICX.ICX_POR_PRICE_LIST_LINES does not reference any database object

ICX.ICX_POR_PRICE_LIST_LINES is referenced by following:

APPS: ICX_POR_PRICE_LIST_LINES