Product: | MSD - Demand Planning |
---|---|
Description: | This view to show price list information |
Implementation/DBA Data: | APPS.MSD_PRICE_LIST_V |
SELECT ORG_PK.LEVEL_ID
, ORG_PK.LEVEL_PK INV_ORG_PK
, ITEM_PK.LEVEL_ID
, ITEM_PK.LEVEL_PK ITEM_PK
, /*CUSTOMER_PK.LEVEL_VALUE
, CUSTOMER_PK.LEVEL_PK CUSTOMER_PK
, */ SALES_CHANNEL_PK.LEVEL_ID
, SALES_CHANNEL_PK.LEVEL_PK SALES_CHANNEL_PK
, SALES_REP_PK.LEVEL_ID
, SALES_REP_PK.LEVEL_PK SALES_REP_PK
, GEO_PK.LEVEL_ID
, GEO_PK.LEVEL_PK GEO_PK
, MPL.USER_DEFINED1_LVL_ID
, NULL USER_DEFINED1_PK
, MPL.USER_DEFINED2_LVL_ID
, NULL USER_DEFINED2_PK
, MPL.PRICE_LIST_NAME PRICE_LIST
, MPL.START_DATE
, MPL.END_DATE
, MPL.PRICE
, MPL.PRIORITY
, MPL.LAST_REFRESH_NUM
, MPL.CREATED_BY_REFRESH_NUM
, MPL.ACTION_CODE
FROM MSD_PRICE_LIST MPL
, MSD_LEVEL_VALUES ORG_PK
, MSD_LEVEL_VALUES ITEM_PK
, /* MSD_LEVEL_VALUES CUSTOMER_PK
, */ MSD_LEVEL_VALUES SALES_CHANNEL_PK
, MSD_LEVEL_VALUES SALES_REP_PK
, MSD_LEVEL_VALUES GEO_PK
WHERE /* INV_ORG_PK */ (ORG_PK.INSTANCE = MPL.INSTANCE
AND ORG_PK.SR_LEVEL_PK = MPL.SR_ORGANIZATION_LVL_PK
AND ORG_PK.LEVEL_ID = MPL.ORGANIZATION_LVL_ID)
AND /* ITEM_PK*/ (ITEM_PK.INSTANCE = MPL.INSTANCE
AND ITEM_PK.SR_LEVEL_PK = MPL.SR_PRODUCT_LVL_PK
AND ITEM_PK.LEVEL_ID = MPL.PRODUCT_LVL_ID)
AND /* SALES_CHANNEL_PK */ (SALES_CHANNEL_PK.INSTANCE = MPL.INSTANCE
AND SALES_CHANNEL_PK.SR_LEVEL_PK = MPL.SR_SALESCHANNEL_LVL_PK
AND SALES_CHANNEL_PK.LEVEL_ID = MPL.SALESCHANNEL_LVL_ID)
AND /* SALES_REP_PK */ (SALES_REP_PK.INSTANCE = MPL.INSTANCE
AND SALES_REP_PK.SR_LEVEL_PK = MPL.SR_SALES_REP_LVL_PK
AND SALES_REP_PK.LEVEL_ID = MPL.SALES_REP_LVL_ID)
AND /* GEO_PK */ (GEO_PK.INSTANCE = MPL.INSTANCE
AND GEO_PK.SR_LEVEL_PK = MPL.SR_GEOGRAPHY_LVL_PK
AND GEO_PK.LEVEL_ID = MPL.GEOGRAPHY_LVL_ID)