DBA Data[Home] [Help] [Dependency Information]

TABLE: ICX.ICX_CAT_PRICE_LISTS

Object Details
Object Name: ICX_CAT_PRICE_LISTS
Object Type: TABLE
Owner: ICX
FND Design Data: TableICX.ICX_CAT_PRICE_LISTS
Subobject Name:
Status: VALID


This table is obsolete since R12.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
ICX_CAT_PRICE_LISTS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPRICE_LIST_ID
ICX_CAT_PRICE_LISTS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSUPPLIER_ID
ColumnNAME
Columns
Name Datatype Length Mandatory Comments
PRICE_LIST_ID NUMBER
Yes Price List unique identifier. Stores Price List ID for bulk-loaded price.
NAME VARCHAR2 (255) Yes Price List Name. Name is 'All-Buyers List Prices' for All Operating Units price list. For Buyer specific price list, list name is stored as '<>+ Price List'
SUPPLIER_ID NUMBER
Yes Supplier ID of the supplier providing the Price List.
BUYER_ID NUMBER
Yes Operating Unit Id, to which the item belongs. A value of '-2' indicates that the item will be available for All Operating Units..
DESCRIPTION VARCHAR2 (2000)
Description of Price List.
CURRENCY VARCHAR2 (4) Yes Transactional Currency.
CREATION_DATE DATE
Yes Standard Who column: date when this record was created
CREATED_BY NUMBER
Yes Standard Who column: the user who created this record. (References FND_USERS.user_id.)
LAST_UPDATE_DATE DATE
Yes Standard Who column: date when this record was last updated
LAST_UPDATED_BY NUMBER
Yes Standard Who column: the user who last updated this record. (References FND_USERS.user_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.)
REQUEST_ID NUMBER

Request Id of Concurrent Job submitted. The concurrent program that created or updated this record. (References FND_CONCURRENT_PROGRAMS.request_id)
BEGINDATE DATE

Begin date
ENDDATE DATE

End date.
STATUS VARCHAR2 (30)
Status. Always APPROVED
PUBLISHED_DATE DATE

Published Date.
OUTDATED_DATE DATE

Date Outdated.
APPROVAL_DATE DATE

Date of approval of price list.
REJECTED_DATE DATE

Date Rejected. Not populated.
DELETED_DATE DATE

Date Deleted.
BUYERCOMMENTS VARCHAR2 (2000)
Comments from buyer.
ACTION VARCHAR2 (30)
Stores Action. Action is ADD when a new price list is added.
TYPE VARCHAR2 (1)
Type of the price list. Type is 'B' for Bulkloaded. We can't extract a price list.
PARENT_HEADER_ID NUMBER

Header ID of the parent price list. Not Used.
Query Text

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


SELECT PRICE_LIST_ID
,      NAME
,      SUPPLIER_ID
,      BUYER_ID
,      DESCRIPTION
,      CURRENCY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      BEGINDATE
,      ENDDATE
,      STATUS
,      PUBLISHED_DATE
,      OUTDATED_DATE
,      APPROVAL_DATE
,      REJECTED_DATE
,      DELETED_DATE
,      BUYERCOMMENTS
,      ACTION
,      TYPE
,      PARENT_HEADER_ID
FROM ICX.ICX_CAT_PRICE_LISTS;

Dependencies

[top of page]

ICX.ICX_CAT_PRICE_LISTS does not reference any database object

ICX.ICX_CAT_PRICE_LISTS is referenced by following:

SchemaICX
ViewICX_CAT_PRICE_LISTS#