VIEW: APPS.MSD_DP_DIMENSIONS_V

Source

View Text - Preformatted

SELECT mdd.rowid, mdd.demand_plan_id, mdp.demand_plan_name, mdd.dp_dimension_code, flv1.meaning, mdd.dimension_code, flv2.meaning, mdd.last_update_date, mdd.last_updated_by, mdd.creation_date, mdd.created_by, mdd.last_update_login, mdd.request_id, mdd.program_application_id, mdd.program_id, mdd.program_update_date, mdd.deleteable_flag , mdd.enable_nonseed_flag from fnd_lookup_values_vl flv1, fnd_lookup_values_vl flv2, msd_demand_plans mdp, msd_dp_dimensions mdd WHERE flv1.lookup_code = mdd.dp_dimension_code and flv1.lookup_type = DECODE(mdp.plan_type,'LIABILITY','MSD_DIMENSIONS_LB','MSD_USER_DIMENSIONS') and flv2.lookup_code = mdd.dimension_code and flv2.lookup_type = DECODE(mdp.plan_type,'LIABILITY','MSD_DIMENSIONS_LB','MSD_DIMENSIONS') and mdp.demand_plan_id = mdd.demand_plan_id

View Text - HTML Formatted

SELECT MDD.ROWID
, MDD.DEMAND_PLAN_ID
, MDP.DEMAND_PLAN_NAME
, MDD.DP_DIMENSION_CODE
, FLV1.MEANING
, MDD.DIMENSION_CODE
, FLV2.MEANING
, MDD.LAST_UPDATE_DATE
, MDD.LAST_UPDATED_BY
, MDD.CREATION_DATE
, MDD.CREATED_BY
, MDD.LAST_UPDATE_LOGIN
, MDD.REQUEST_ID
, MDD.PROGRAM_APPLICATION_ID
, MDD.PROGRAM_ID
, MDD.PROGRAM_UPDATE_DATE
, MDD.DELETEABLE_FLAG
, MDD.ENABLE_NONSEED_FLAG
FROM FND_LOOKUP_VALUES_VL FLV1
, FND_LOOKUP_VALUES_VL FLV2
, MSD_DEMAND_PLANS MDP
, MSD_DP_DIMENSIONS MDD
WHERE FLV1.LOOKUP_CODE = MDD.DP_DIMENSION_CODE
AND FLV1.LOOKUP_TYPE = DECODE(MDP.PLAN_TYPE
, 'LIABILITY'
, 'MSD_DIMENSIONS_LB'
, 'MSD_USER_DIMENSIONS')
AND FLV2.LOOKUP_CODE = MDD.DIMENSION_CODE
AND FLV2.LOOKUP_TYPE = DECODE(MDP.PLAN_TYPE
, 'LIABILITY'
, 'MSD_DIMENSIONS_LB'
, 'MSD_DIMENSIONS')
AND MDP.DEMAND_PLAN_ID = MDD.DEMAND_PLAN_ID