VIEW: APPS.MSD_DP_HIERARCHIES_V

Source

View Text - Preformatted

SELECT mdh.rowid, mdh.demand_plan_id, mdp.demand_plan_name, mdh.dp_dimension_code, flv1.meaning, mdh.hierarchy_id, mhv.hierarchy_name, mhv.description, mhv.dimension_code, flv1.meaning, mdh.last_update_date, mdh.last_updated_by, mdh.creation_date, mdh.created_by, mdh.last_update_login, mdh.request_id, mdh.program_application_id, mdh.program_id, mdh.program_update_date ,mdh.deleteable_flag ,mdh.enable_nonseed_flag from fnd_lookup_values_vl flv1, msd_demand_plans mdp, msd_hierarchies mhv, mfg_lookups ml, msd_dp_hierarchies mdh WHERE flv1.lookup_code = mdh.dp_dimension_code and flv1.lookup_type = decode(mdp.plan_type,'LIABILITY','MSD_DIMENSIONS_LB','MSD_USER_DIMENSIONS') and mhv.hierarchy_id = mdh.hierarchy_id and mdp.demand_plan_id = mdh.demand_plan_id and ml.lookup_code = mhv.valid_flag and ml.lookup_type = 'SYS_YES_NO' and nvl(mhv.plan_type,'DP') = DECODE(mdp.plan_type,'SOP','DP','EOL','DP','','DP',mdp.plan_type)

View Text - HTML Formatted

SELECT MDH.ROWID
, MDH.DEMAND_PLAN_ID
, MDP.DEMAND_PLAN_NAME
, MDH.DP_DIMENSION_CODE
, FLV1.MEANING
, MDH.HIERARCHY_ID
, MHV.HIERARCHY_NAME
, MHV.DESCRIPTION
, MHV.DIMENSION_CODE
, FLV1.MEANING
, MDH.LAST_UPDATE_DATE
, MDH.LAST_UPDATED_BY
, MDH.CREATION_DATE
, MDH.CREATED_BY
, MDH.LAST_UPDATE_LOGIN
, MDH.REQUEST_ID
, MDH.PROGRAM_APPLICATION_ID
, MDH.PROGRAM_ID
, MDH.PROGRAM_UPDATE_DATE
, MDH.DELETEABLE_FLAG
, MDH.ENABLE_NONSEED_FLAG
FROM FND_LOOKUP_VALUES_VL FLV1
, MSD_DEMAND_PLANS MDP
, MSD_HIERARCHIES MHV
, MFG_LOOKUPS ML
, MSD_DP_HIERARCHIES MDH
WHERE FLV1.LOOKUP_CODE = MDH.DP_DIMENSION_CODE
AND FLV1.LOOKUP_TYPE = DECODE(MDP.PLAN_TYPE
, 'LIABILITY'
, 'MSD_DIMENSIONS_LB'
, 'MSD_USER_DIMENSIONS')
AND MHV.HIERARCHY_ID = MDH.HIERARCHY_ID
AND MDP.DEMAND_PLAN_ID = MDH.DEMAND_PLAN_ID
AND ML.LOOKUP_CODE = MHV.VALID_FLAG
AND ML.LOOKUP_TYPE = 'SYS_YES_NO'
AND NVL(MHV.PLAN_TYPE
, 'DP') = DECODE(MDP.PLAN_TYPE
, 'SOP'
, 'DP'
, 'EOL'
, 'DP'
, ''
, 'DP'
, MDP.PLAN_TYPE)