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

TABLE: MSD.MSD_DP_PRICE_LISTS

Object Details
Object Name: MSD_DP_PRICE_LISTS
Object Type: TABLE
Owner: MSD
FND Design Data: TableMSD.MSD_DP_PRICE_LISTS
Subobject Name:
Status: VALID


This table stores Deman Plan's Price Lists.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MSD_DP_PRICE_LISTS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnDEMAND_PLAN_ID
ColumnPRICE_LIST_NAME
MSD_DP_PRICE_LISTS_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnDP_PRICE_LIST_ID
Columns
Name Datatype Length Mandatory Comments
DP_PRICE_LIST_ID NUMBER (15) Yes Primary Key
DEMAND_PLAN_ID NUMBER (15) Yes Primary Key
PRICE_LIST_NAME VARCHAR2 (240) Yes Price List Name
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.
REQUEST_ID NUMBER

Extended Who Column.
PROGRAM_APPLICATION_ID NUMBER

Extended Who Column.
PROGRAM_ID NUMBER

Extended Who Column.
PROGRAM_UPDATE_DATE DATE

Extended Who Column.
DELETEABLE_FLAG VARCHAR2 (15)
Indicates whether the record is deleteable or not
ENABLE_NONSEED_FLAG VARCHAR2 (15)
Indicates whether the fields for this record need to be disabled for non seeded records also
Query Text

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


SELECT DP_PRICE_LIST_ID
,      DEMAND_PLAN_ID
,      PRICE_LIST_NAME
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      DELETEABLE_FLAG
,      ENABLE_NONSEED_FLAG
FROM MSD.MSD_DP_PRICE_LISTS;

Dependencies

[top of page]

MSD.MSD_DP_PRICE_LISTS does not reference any database object

MSD.MSD_DP_PRICE_LISTS is referenced by following:

SchemaAPPS
SynonymMSD_DP_PRICE_LISTS