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

TABLE: PON.PON_PRICE_ELEMENT_LISTS

Object Details
Object Name: PON_PRICE_ELEMENT_LISTS
Object Type: TABLE
Owner: PON
FND Design Data: TablePON.PON_PRICE_ELEMENT_LISTS
Subobject Name:
Status: VALID


PON_PRICE_ELEMENT_LISTS stores details of price element lists.Each row includes specific information about each price element list such as list ID, list status, trading partner ID, name, description etc.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PON_PRICE_ELEMENT_LISTS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnLIST_ID
PON_PRICE_ELEMENT_LISTS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRADING_PARTNER_ID
Columns
Name Datatype Length Mandatory Comments
LIST_ID NUMBER
Yes Unique system generated ID of the price element list
LIST_NAME VARCHAR2 (80) Yes Name of the price element list
DESCRIPTION VARCHAR2 (240)
Description of the price element list
LIST_STATUS VARCHAR2 (30) Yes Status of the List. ACTIVE / INACTIVE
TRADING_PARTNER_ID NUMBER
Yes company trading partner id
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
Query Text

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


SELECT LIST_ID
,      LIST_NAME
,      DESCRIPTION
,      LIST_STATUS
,      TRADING_PARTNER_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
FROM PON.PON_PRICE_ELEMENT_LISTS;

Dependencies

[top of page]

PON.PON_PRICE_ELEMENT_LISTS does not reference any database object

PON.PON_PRICE_ELEMENT_LISTS is referenced by following:

SchemaAPPS
SynonymPON_PRICE_ELEMENT_LISTS