VIEW: APPS.MSD_PRICE_LIST_DS_V

Source

View Text - Preformatted

SELECT mds.demand_plan_id, 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, to_number(null) USER_DEFINED1_PK, mpl.User_defined2_lvl_id, to_number(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, dcs_pk.level_id, dcs_pk.level_pk, '0' COST_FLAG from msd_price_list mpl, msd_dp_session mds, msd_level_values_ds org_pk, msd_level_values_ds dcs_pk, msd_level_values_ds item_pk, /* msd_level_values_ds customer_pk, */ msd_level_values_ds sales_channel_pk, msd_level_values_ds sales_rep_pk, msd_level_values_ds 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 /* dcs_pk */ (dcs_pk.instance (+) = mpl.instance and dcs_pk.sr_level_pk (+) = mpl.sr_demand_class_lvl_pk and dcs_pk.level_id (+) = mpl.demand_class_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) and item_pk.demand_plan_id = mds.demand_plan_id and org_pk.demand_plan_id = mds.demand_plan_id and geo_pk.demand_plan_id = mds.demand_plan_id and sales_channel_pk.demand_plan_id = mds.demand_plan_id and sales_rep_pk.demand_plan_id = mds.demand_plan_id

View Text - HTML Formatted

SELECT MDS.DEMAND_PLAN_ID
, 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
, TO_NUMBER(NULL) USER_DEFINED1_PK
, MPL.USER_DEFINED2_LVL_ID
, TO_NUMBER(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
, DCS_PK.LEVEL_ID
, DCS_PK.LEVEL_PK
, '0' COST_FLAG
FROM MSD_PRICE_LIST MPL
, MSD_DP_SESSION MDS
, MSD_LEVEL_VALUES_DS ORG_PK
, MSD_LEVEL_VALUES_DS DCS_PK
, MSD_LEVEL_VALUES_DS ITEM_PK
, /* MSD_LEVEL_VALUES_DS CUSTOMER_PK
, */ MSD_LEVEL_VALUES_DS SALES_CHANNEL_PK
, MSD_LEVEL_VALUES_DS SALES_REP_PK
, MSD_LEVEL_VALUES_DS 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 /* DCS_PK */ (DCS_PK.INSTANCE (+) = MPL.INSTANCE
AND DCS_PK.SR_LEVEL_PK (+) = MPL.SR_DEMAND_CLASS_LVL_PK
AND DCS_PK.LEVEL_ID (+) = MPL.DEMAND_CLASS_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)
AND ITEM_PK.DEMAND_PLAN_ID = MDS.DEMAND_PLAN_ID
AND ORG_PK.DEMAND_PLAN_ID = MDS.DEMAND_PLAN_ID
AND GEO_PK.DEMAND_PLAN_ID = MDS.DEMAND_PLAN_ID
AND SALES_CHANNEL_PK.DEMAND_PLAN_ID = MDS.DEMAND_PLAN_ID
AND SALES_REP_PK.DEMAND_PLAN_ID = MDS.DEMAND_PLAN_ID