eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.MSD_SR_PRICE_LIST_V

Object Details

Object Name:	MSD_SR_PRICE_LIST_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	MSD.MSD_SR_PRICE_LIST_V
Subobject Name:
Status:	VALID

View Type

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

This source view gathers the price list information defined.

[View Source]

Columns

Name	Datatype	Length	Comments
ORGANIZATION_LVL_ID	NUMBER		Organization Lvl Id
SR_ORGANIZATION_LVL_PK	NUMBER		Organization Lvl Pk
PRODUCT_LVL_ID	NUMBER		Product Lvl Id
SR_PRODUCT_LVL_PK	NUMBER		Product Lvl Pk
SALESCHANNEL_LVL_ID	NUMBER		Saleschannel Lvl Id
SR_SALESCHANNEL_LVL_PK	NUMBER		Saleschannel Lvl Pk
SALES_REP_LVL_ID	NUMBER		Sales Rep Lvl Id
SR_SALES_REP_LVL_PK	NUMBER		Sales Rep Lvl Pk
GEOGRAPHY_LVL_ID	NUMBER		Geography Lvl Id
SR_GEOGRAPHY_LVL_PK	NUMBER		Geography Lvl Pk
USER_DEFINED1_LVL_ID	NUMBER		User Defined1 Lvl Id
SR_USER_DEFINED1_LVL_PK	VARCHAR2	(0)	User Defined1 Lvl Pk
USER_DEFINED2_LVL_ID	NUMBER		User Defined2 Lvl Id
SR_USER_DEFINED2_LVL_PK	VARCHAR2	(0)	User Defined2 Lvl Pk
PRICE_LIST_NAME	VARCHAR2	(240)	Price List Name
START_DATE	DATE		Start Date
END_DATE	DATE		End Date
PRICE	NUMBER		Price
PRIORITY	NUMBER		Priority
PRIMARY_UOM_FLAG	VARCHAR2	(1)	Primary UOM Flag
PRICE_LIST_UOM	VARCHAR2	(3)	Price List UOM
SOURCE_SYSTEM_CODE	VARCHAR2	(30)	Source System Code
DEMAND_CLASS_LVL_ID	NUMBER		Demand Class Level ID
SR_DEMAND_CLASS_LVL_PK	NUMBER		Source Demand Class Primary Key

Query Text

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


SELECT ORGANIZATION_LVL_ID
,      SR_ORGANIZATION_LVL_PK
,      PRODUCT_LVL_ID
,      SR_PRODUCT_LVL_PK
,      SALESCHANNEL_LVL_ID
,      SR_SALESCHANNEL_LVL_PK
,      SALES_REP_LVL_ID
,      SR_SALES_REP_LVL_PK
,      GEOGRAPHY_LVL_ID
,      SR_GEOGRAPHY_LVL_PK
,      USER_DEFINED1_LVL_ID
,      SR_USER_DEFINED1_LVL_PK
,      USER_DEFINED2_LVL_ID
,      SR_USER_DEFINED2_LVL_PK
,      PRICE_LIST_NAME
,      START_DATE
,      END_DATE
,      PRICE
,      PRIORITY
,      PRIMARY_UOM_FLAG
,      PRICE_LIST_UOM
,      SOURCE_SYSTEM_CODE
,      DEMAND_CLASS_LVL_ID
,      SR_DEMAND_CLASS_LVL_PK
FROM APPS.MSD_SR_PRICE_LIST_V;

Dependencies

[top of page]

APPS.MSD_SR_PRICE_LIST_V references the following:

APPS: MSD_APP_INSTANCE_ORGS; MSD_SETUP_PARAMETERS; MSD_SR_UTIL - show dependent code; MTL_ITEM_CATEGORIES; MTL_SYSTEM_ITEMS; QP_LIST_HEADERS_VL; QP_LIST_LINES; QP_PRICE_REQ_SOURCES_V; QP_PRICING_ATTRIBUTES

APPS.MSD_SR_PRICE_LIST_V is not referenced by any database object