[Home] [Help]
[Dependency Information]
Object Name: | MSD_SR_PRICE_LIST_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ![]() |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This source view gathers the price list information defined.
Name | Datatype | Length | Mandatory | 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 |
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;
APPS.MSD_SR_PRICE_LIST_V is not referenced by any database object
|
|
|