VIEW: APPS.MSD_DEMAND_PLANS_VL

Source

View Text - Preformatted

SELECT mdp.ROWID ROW_ID, mdp.DEMAND_PLAN_ID, mdp.ORGANIZATION_ID, mdp.SR_INSTANCE_ID, mdp.DEMAND_PLAN_NAME, mdp_tl.DESCRIPTION, mdp.CALENDAR_TYPE CALENDAR_TYPE_ID, null "CALENDAR_TYPE", mdp.CALENDAR_CODE, mdp.PERIOD_SET_NAME, mdp.BASE_UOM, fnd_profile.value('MSD_CURRENCY_CODE') CURRENCY_CODE, mdp.AVERAGE_DISCOUNT, mdp.CATEGORY_SET_ID, mcs.CATEGORY_SET_NAME, mdp.lowest_period_type LOWEST_PERIOD_TYPE_ID, flv2.meaning "LOWEST_PERIOD_TYPE", mdp.history_start_date, mdp.valid_flag, flv3.meaning "VALID_FLAG_DESC", mdp.enable_fcst_explosion, mdp.delete_plan_flag, mdp.roundoff_threashold, mdp.roundoff_decimal_places, mdp.LAST_UPDATE_DATE, mdp.LAST_UPDATED_BY, mdp.CREATION_DATE, mdp.CREATED_BY, mdp.LAST_UPDATE_LOGIN, mdp.REQUEST_ID, mdp.PROGRAM_APPLICATION_ID, mdp.PROGRAM_ID, mdp.PROGRAM_UPDATE_DATE, mdp.ATTRIBUTE_CATEGORY, mdp.ATTRIBUTE1, mdp.ATTRIBUTE2, mdp.ATTRIBUTE3, mdp.ATTRIBUTE4, mdp.ATTRIBUTE5, mdp.ATTRIBUTE6, mdp.ATTRIBUTE7, mdp.ATTRIBUTE8, mdp.ATTRIBUTE9, mdp.ATTRIBUTE10, mdp.ATTRIBUTE11, mdp.ATTRIBUTE12, mdp.ATTRIBUTE13, mdp.ATTRIBUTE14, mdp.ATTRIBUTE15, mes.SHARED_DB_PREFIX, mes.CODE_LOCATION, mes.SHARED_DB_LOCATION, mes.EXPRESS_MACHINE_PORT, mes.OWA_VIRTUAL_PATH_NAME, mes.EAD_NAME, mes.EXPRESS_CONNECT_STRING, mes.SETUP1, mes.SETUP2, mes.SETUP3, mes.SETUP4, mes.SETUP5, mdp.amt_threshold, mdp.amt_decimal_places, mdp.dp_build_refresh_num, mdp.g_min_tim_lvl_id, mdp.m_min_tim_lvl_id, mdp.f_min_tim_lvl_id, mdp.c_min_tim_lvl_id, decode(mdp.build_stripe_level_pk, null, decode(mdp.build_stripe_stream_name,null, null,'Y') , 'Y') STRIPE_FLAG, mdp.stripe_instance, mdp.stripe_level_id, mdp.stripe_sr_level_pk, mdp.build_stripe_level_pk, mdp.rounding_level_id, mdp.stripe_stream_name, mdp.stripe_stream_desig, mdp.build_stripe_stream_name, mdp.build_stripe_stream_desig, mdp.build_stripe_stream_ref_num, mdp.use_org_specific_bom_flag, flv4.meaning use_org_specific_bom_flag_DESC, mdp.delete_request_id, mdp.template_id, mdp.template_flag, mdp.default_template, mdp.plan_type, mdp.plan_start_date from fnd_lookup_values_vl flv2, fnd_lookup_values_vl flv3, msc_category_sets mcs, msd_demand_plans mdp, msd_demand_plans_tl mdp_tl, msd_dp_express_setup mes, fnd_lookup_values_vl flv4 WHERE flv2.lookup_code = mdp.lowest_period_type and flv2.lookup_type = 'MSD_PERIOD_TYPE' and flv3.lookup_code (+) = mdp.valid_flag and flv3.lookup_type (+) = 'MSD_DEMAND_PLAN_VALID_STATUS' and mcs.category_set_id (+) = mdp.category_set_id and mdp.demand_plan_id = mes.demand_plan_id (+) and flv4.lookup_type (+) ='MSD_DP_BOM_TYPE' and flv4.lookup_code (+) = mdp.use_org_specific_bom_flag and mdp.demand_plan_id = mdp_tl.demand_plan_id and mdp_tl.language = userenv('LANG')

View Text - HTML Formatted

SELECT MDP.ROWID ROW_ID
, MDP.DEMAND_PLAN_ID
, MDP.ORGANIZATION_ID
, MDP.SR_INSTANCE_ID
, MDP.DEMAND_PLAN_NAME
, MDP_TL.DESCRIPTION
, MDP.CALENDAR_TYPE CALENDAR_TYPE_ID
, NULL "CALENDAR_TYPE"
, MDP.CALENDAR_CODE
, MDP.PERIOD_SET_NAME
, MDP.BASE_UOM
, FND_PROFILE.VALUE('MSD_CURRENCY_CODE') CURRENCY_CODE
, MDP.AVERAGE_DISCOUNT
, MDP.CATEGORY_SET_ID
, MCS.CATEGORY_SET_NAME
, MDP.LOWEST_PERIOD_TYPE LOWEST_PERIOD_TYPE_ID
, FLV2.MEANING "LOWEST_PERIOD_TYPE"
, MDP.HISTORY_START_DATE
, MDP.VALID_FLAG
, FLV3.MEANING "VALID_FLAG_DESC"
, MDP.ENABLE_FCST_EXPLOSION
, MDP.DELETE_PLAN_FLAG
, MDP.ROUNDOFF_THREASHOLD
, MDP.ROUNDOFF_DECIMAL_PLACES
, MDP.LAST_UPDATE_DATE
, MDP.LAST_UPDATED_BY
, MDP.CREATION_DATE
, MDP.CREATED_BY
, MDP.LAST_UPDATE_LOGIN
, MDP.REQUEST_ID
, MDP.PROGRAM_APPLICATION_ID
, MDP.PROGRAM_ID
, MDP.PROGRAM_UPDATE_DATE
, MDP.ATTRIBUTE_CATEGORY
, MDP.ATTRIBUTE1
, MDP.ATTRIBUTE2
, MDP.ATTRIBUTE3
, MDP.ATTRIBUTE4
, MDP.ATTRIBUTE5
, MDP.ATTRIBUTE6
, MDP.ATTRIBUTE7
, MDP.ATTRIBUTE8
, MDP.ATTRIBUTE9
, MDP.ATTRIBUTE10
, MDP.ATTRIBUTE11
, MDP.ATTRIBUTE12
, MDP.ATTRIBUTE13
, MDP.ATTRIBUTE14
, MDP.ATTRIBUTE15
, MES.SHARED_DB_PREFIX
, MES.CODE_LOCATION
, MES.SHARED_DB_LOCATION
, MES.EXPRESS_MACHINE_PORT
, MES.OWA_VIRTUAL_PATH_NAME
, MES.EAD_NAME
, MES.EXPRESS_CONNECT_STRING
, MES.SETUP1
, MES.SETUP2
, MES.SETUP3
, MES.SETUP4
, MES.SETUP5
, MDP.AMT_THRESHOLD
, MDP.AMT_DECIMAL_PLACES
, MDP.DP_BUILD_REFRESH_NUM
, MDP.G_MIN_TIM_LVL_ID
, MDP.M_MIN_TIM_LVL_ID
, MDP.F_MIN_TIM_LVL_ID
, MDP.C_MIN_TIM_LVL_ID
, DECODE(MDP.BUILD_STRIPE_LEVEL_PK
, NULL
, DECODE(MDP.BUILD_STRIPE_STREAM_NAME
, NULL
, NULL
, 'Y')
, 'Y') STRIPE_FLAG
, MDP.STRIPE_INSTANCE
, MDP.STRIPE_LEVEL_ID
, MDP.STRIPE_SR_LEVEL_PK
, MDP.BUILD_STRIPE_LEVEL_PK
, MDP.ROUNDING_LEVEL_ID
, MDP.STRIPE_STREAM_NAME
, MDP.STRIPE_STREAM_DESIG
, MDP.BUILD_STRIPE_STREAM_NAME
, MDP.BUILD_STRIPE_STREAM_DESIG
, MDP.BUILD_STRIPE_STREAM_REF_NUM
, MDP.USE_ORG_SPECIFIC_BOM_FLAG
, FLV4.MEANING USE_ORG_SPECIFIC_BOM_FLAG_DESC
, MDP.DELETE_REQUEST_ID
, MDP.TEMPLATE_ID
, MDP.TEMPLATE_FLAG
, MDP.DEFAULT_TEMPLATE
, MDP.PLAN_TYPE
, MDP.PLAN_START_DATE
FROM FND_LOOKUP_VALUES_VL FLV2
, FND_LOOKUP_VALUES_VL FLV3
, MSC_CATEGORY_SETS MCS
, MSD_DEMAND_PLANS MDP
, MSD_DEMAND_PLANS_TL MDP_TL
, MSD_DP_EXPRESS_SETUP MES
, FND_LOOKUP_VALUES_VL FLV4
WHERE FLV2.LOOKUP_CODE = MDP.LOWEST_PERIOD_TYPE
AND FLV2.LOOKUP_TYPE = 'MSD_PERIOD_TYPE'
AND FLV3.LOOKUP_CODE (+) = MDP.VALID_FLAG
AND FLV3.LOOKUP_TYPE (+) = 'MSD_DEMAND_PLAN_VALID_STATUS'
AND MCS.CATEGORY_SET_ID (+) = MDP.CATEGORY_SET_ID
AND MDP.DEMAND_PLAN_ID = MES.DEMAND_PLAN_ID (+)
AND FLV4.LOOKUP_TYPE (+) ='MSD_DP_BOM_TYPE'
AND FLV4.LOOKUP_CODE (+) = MDP.USE_ORG_SPECIFIC_BOM_FLAG
AND MDP.DEMAND_PLAN_ID = MDP_TL.DEMAND_PLAN_ID
AND MDP_TL.LANGUAGE = USERENV('LANG')