DBA Data[Home] [Help]

VIEW: APPS.MSD_ITEM_MASTER_LB_V

Source

View Text - Preformatted

SELECT mdp.demand_plan_id, dp_itm.level_pk, 1, 1, MSD_COMMON_UTILITIES_LB .get_base_uom(dp_itm.sr_level_pk, dp_itm.plan_id) FROM msd_level_values_lb dp_itm, msd_demand_plans mdp WHERE dp_itm.level_id = 1 and dp_itm.plan_id = mdp.liab_plan_id
View Text - HTML Formatted

SELECT MDP.DEMAND_PLAN_ID
, DP_ITM.LEVEL_PK
, 1
, 1
, MSD_COMMON_UTILITIES_LB .GET_BASE_UOM(DP_ITM.SR_LEVEL_PK
, DP_ITM.PLAN_ID)
FROM MSD_LEVEL_VALUES_LB DP_ITM
, MSD_DEMAND_PLANS MDP
WHERE DP_ITM.LEVEL_ID = 1
AND DP_ITM.PLAN_ID = MDP.LIAB_PLAN_ID