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

VIEW: APPS.MSD_PRICE_LIST_LB_V

Object Details
Object Name: MSD_PRICE_LIST_LB_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

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


For Liability Analysis, this view to show price list information


[View Source]

Columns
Name Datatype Length Mandatory Comments
DEMAND_PLAN_ID NUMBER
Yes Demand Plan Id
ORGANIZATION_LVL_PK NUMBER
Yes Organization Lvl Pk
PRODUCT_LVL_PK NUMBER
Yes Product Lvl Pk
SALESCHANNEL_LVL_PK NUMBER

Saleschannel Lvl Pk
SALES_REP_LVL_PK NUMBER

Sales Rep Lvl Pk
GEOGRAPHY_LVL_PK NUMBER
Yes Geography Lvl Pk
USER_DEFINED1_LVL_PK NUMBER

User Defined1 Lvl Pk
USER_DEFINED2_LVL_PK NUMBER

User Defined2 Lvl Pk
DCS_LEVEL_VALUE_PK NUMBER

Demand Class Level Value PK
PRICE_LIST_NAME VARCHAR2 (4000)
Price List Name
START_DATE DATE

Start Date
END_DATE DATE

End Date
PRICE NUMBER

Price
PRIORITY NUMBER

Priority
CREATED_BY_REFRESH_NUM NUMBER

created by refresh number
ACTION_CODE CHAR (1)
DML action code
Query Text

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


SELECT DEMAND_PLAN_ID
,      ORGANIZATION_LVL_PK
,      PRODUCT_LVL_PK
,      SALESCHANNEL_LVL_PK
,      SALES_REP_LVL_PK
,      GEOGRAPHY_LVL_PK
,      USER_DEFINED1_LVL_PK
,      USER_DEFINED2_LVL_PK
,      DCS_LEVEL_VALUE_PK
,      PRICE_LIST_NAME
,      START_DATE
,      END_DATE
,      PRICE
,      PRIORITY
,      CREATED_BY_REFRESH_NUM
,      ACTION_CODE
FROM APPS.MSD_PRICE_LIST_LB_V;

Dependencies

[top of page]

APPS.MSD_PRICE_LIST_LB_V references the following:

SchemaAPPS
PL/SQL PackageFND_MESSAGE - show dependent code
SynonymMSC_ITEM_SUPPLIERS
SynonymMSC_PLANS
SynonymMSC_SYSTEM_ITEMS
SynonymMSC_TRADING_PARTNERS
SynonymMSD_DEMAND_PLANS
SynonymMSD_LEVEL_VALUES_LB
SchemaPUBLIC
SynonymDUAL

APPS.MSD_PRICE_LIST_LB_V is not referenced by any database object