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

VIEW: APPS.MSD_DP_PRICE_LISTS_V

Object Details
Object Name: MSD_DP_PRICE_LISTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewMSD.MSD_DP_PRICE_LISTS_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


This view to display price list information


[View Source]

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
LAST_UPDATE_DATE DATE
Yes Standard Who Column.
LAST_UPDATED_BY NUMBER
Yes Standard Who Column.
CREATION_DATE DATE
Yes Standard Who Column.
CREATED_BY NUMBER
Yes Standard Who Column.
LAST_UPDATE_LOGIN NUMBER

Standard 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
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      DELETEABLE_FLAG
,      ENABLE_NONSEED_FLAG
FROM APPS.MSD_DP_PRICE_LISTS_V;

Dependencies

[top of page]

APPS.MSD_DP_PRICE_LISTS_V references the following:

SchemaAPPS
SynonymMSD_DP_PRICE_LISTS

APPS.MSD_DP_PRICE_LISTS_V is not referenced by any database object