[Home] [Help] [Dependency Information]
Object Name: | ICX_CAT_PRICE_LISTS |
---|---|
Object Type: | TABLE |
Owner: | ICX |
FND Design Data: | ICX.ICX_CAT_PRICE_LISTS |
Subobject Name: | |
Status: | VALID |
This table is obsolete since R12.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
ICX_CAT_PRICE_LISTS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | PRICE_LIST_ID |
ICX_CAT_PRICE_LISTS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
SUPPLIER_ID
NAME |
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 '< |
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. |
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;
ICX.ICX_CAT_PRICE_LISTS does not reference any database object
ICX.ICX_CAT_PRICE_LISTS is referenced by following:
|
|
|