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

TABLE: ICX.ICX_POR_PRICE_LIST_LINES_CACHE

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


Cache table for price list lines information.
When maintaining item pricing information, the table is used as a cache, while the users are in the process of making their changes. This table stores the same level of data as ICX_POR_PRICE_LIST_LINES but only for the set of records being edited/created/deleted.
When a user is making online changes to price lines, those affected price lines are stored in this cache table and the changes are available to the user for review prior to submission.


Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
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

unit price
UOM VARCHAR2 (30)
unit of measure
CURRENCY_CODE VARCHAR2 (4) Yes Currency Code
BUYER_APPROVAL_STATUS VARCHAR2 (30)
Buyer approval status
COMMENTS VARCHAR2 (2000)
Buyer Comments
PRICE_CODE VARCHAR2 (30)
Price Code
SUPPLIERCOMMENTS VARCHAR2 (2000)
Supplier Comments
EFFECTIVE_BEGINDATE DATE

Effective begin date
EFFECTIVE_ENDDATE DATE

Effective end date
BEGINDATE DATE

Begin date
ENDDATE DATE

End date
LIST_NAME VARCHAR2 (90)
Price List Name
DB_ACTION VARCHAR2 (10)
Database Action - ADD/EDIT/DELETE
SESSION_KEY VARCHAR2 (250) Yes Unique Identifier for the user session
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
,      COMMENTS
,      PRICE_CODE
,      SUPPLIERCOMMENTS
,      EFFECTIVE_BEGINDATE
,      EFFECTIVE_ENDDATE
,      BEGINDATE
,      ENDDATE
,      LIST_NAME
,      DB_ACTION
,      SESSION_KEY
FROM ICX.ICX_POR_PRICE_LIST_LINES_CACHE;

Dependencies

[top of page]

ICX.ICX_POR_PRICE_LIST_LINES_CACHE does not reference any database object

ICX.ICX_POR_PRICE_LIST_LINES_CACHE is referenced by following:

SchemaICX
ViewICX_POR_PRICE_LIST_LINES_CACH#