eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.MSC_PDR_PLAN_DETAILS_V1

Source

View Text - Preformatted


SELECT to_char(null), to_char(null), decode(PP.CURR_PLANNED_RESOURCES,1,'All Resources',2,'Bottleneck Resources'), decode(PP.CURR_PART_INCLUDE_TYPE,1,'All Planned Items', 2, 'Demand Schedule Items only', 3, 'Supply Schedule Items Only', 4, 'Demand and Supply Schedule Items'), nvl(PP.CURR_SR_ASSIGNMENT_SET,' '), nvl(PP.CURR_DEM_PRIORITY_RULE,' '), decode(PP.CURR_OPERATION_SCHEDULE_TYPE,1,'Operation Start Date', 2, 'Order Start Date'), decode(PP.CURR_APPEND_PLANNED_ORDERS,1,'Yes', 2, 'No'), decode(PP.CURR_FULL_PEGGING,1,'Yes', 2, 'No'), decode(PP.CURR_DEMAND_TIME_FENCE_FLAG,1,'Yes', 2, 'No'), decode(PP.CURR_PLANNING_TIME_FENCE_FLAG,1,'Yes', 2, 'No'), decode(PP.LOT_FOR_LOT,1,'Yes', 2, 'No'), PP.COMPILE_DESIGNATOR, to_char(PP.curr_cutoff_DATE), decode(PP.OPTIMIZE_FLAG,1,'Yes', 2, 'No'), decode(PP.CURR_ENFORCE_CAP_CONSTRAINTS,1,'Yes', 2, 'No'), decode(PP.CURR_ENFORCE_DEM_DUE_DATES,1,'Yes', 2, 'No'), nvl(PP.OBJECTIVE_WEIGHT_1,0), nvl(PP.OBJECTIVE_WEIGHT_2,0), nvl(PP.OBJECTIVE_WEIGHT_4,0), nvl(PP.SUPPLIER_CAP_OVER_UTIL_COST,0), nvl(PP.RESOURCE_OVER_UTIL_COST,0), nvl(PP.TRANSPORT_CAP_OVER_UTIL_COST,0), nvl(PP.DMD_LATENESS_PENALTY_COST,0), nvl(PP.DAILY_CUTOFF_BUCKET,0), decode(PP.DAILY_ITEM_AGGREGATION_LEVEL,1,'Items',2,'Product Family'), decode(PP.DAILY_RES_AGGREGATION_LEVEL,1, 'Individual',2,'Aggregate'), decode(PP.DAILY_RTG_AGGREGATION_LEVEL,1,'Routings',2,'BOR'), decode(PP.DAILY_RESOURCE_CONSTRAINTS,1,'Yes', 2, 'No'), decode(PP.DAILY_MATERIAL_CONSTRAINTS,1,'Yes', 2, 'No'), nvl(PP.WEEKLY_CUTOFF_BUCKET,0), decode(PP.WEEKLY_ITEM_AGGREGATION_LEVEL,1,'Items',2,'Product Family'), decode(PP.WEEKLY_RES_AGGREGATION_LEVEL,1, 'Individual',2,'Aggregate'), decode(PP.WEEKLY_RTG_AGGREGATION_LEVEL,1,'Routings',2,'BOR'), decode(PP.WEEKLY_RESOURCE_CONSTRAINTS,1,'Yes', 2, 'No'), decode(PP.WEEKLY_MATERIAL_CONSTRAINTS,1,'Yes', 2, 'No'), nvl(PP.PERIOD_CUTOFF_BUCKET,0), decode(PP.PERIOD_ITEM_AGGREGATION_LEVEL,1,'Items',2,'Product Family'), decode(PP.PERIOD_RES_AGGREGATION_LEVEL,1, 'Individual',2,'Aggregate'), decode(PP.PERIOD_RTG_AGGREGATION_LEVEL,1,'Routings',2,'BOR'), decode(PP.PERIOD_RESOURCE_CONSTRAINTS,1,'Yes', 2, 'No'), decode(PP.PERIOD_MATERIAL_CONSTRAINTS,1,'Yes', 2, 'No'), to_char(null), pp.compile_designator, to_char(trunc(sysdate)), pp.plan_id, pp.organization_id, pp.sr_instance_id, null, null, null, null, null, null, null, null, null, null, null, null, null, to_char(PP.curr_start_DATE) ,decode(PP.use_end_item_substitutions, null , 'No', 1, 'Yes',2, 'No') ,decode(PP.use_alternate_resources,null, 'Yes', 1,'Yes',2,'No') ,decode(PP.use_alternate_bom_routing,null, 'Yes', 1,'Yes',2,'No') ,decode(PP.use_substitute_components,null, 'Yes', 1,'Yes',2,'No') ,decode(PP.use_alternate_sources,null, 'Yes', 1,'Yes',2,'No') ,PP.substitution_set ,pp.curr_plan_type ,decode(pp.curr_hard_pegging_level, null, 'None', 1, 'Project',2, 'Project-Task', 3, 'None') ,decode(pp.curr_reservation_level, null, 'None', 1, 'Planning Group ',2, 'Project ', 3, 'Project-Task ',4, 'None ') ,decode(pp.curr_enable_closest_qty_peg, null , 'No', 1, 'Yes',2, 'No') ,decode(pp.curr_enable_priority_pegging, null , 'No', 1, 'Yes',2, 'No') FROM MSC_PDR_PARAMETERS_new parm2, msc_plans xpp, MSC_PLAN_PARAMETERS_V PP WHERE xPP.plan_id = parm2.number1 and parm2.user_id = fnd_global.user_id and parm2.parm_type = 2 and pp.plan_id = xpp.plan_id and pp.organization_id = xpp.organization_id and pp.sr_instance_id = xpp.sr_instance_id and pp.compile_designator = xpp.compile_designator

View Text - HTML Formatted

SELECT TO_CHAR(NULL)
, TO_CHAR(NULL)
, DECODE(PP.CURR_PLANNED_RESOURCES
, 1
, 'ALL RESOURCES'
, 2
, 'BOTTLENECK RESOURCES')
, DECODE(PP.CURR_PART_INCLUDE_TYPE
, 1
, 'ALL PLANNED ITEMS'
, 2
, 'DEMAND SCHEDULE ITEMS ONLY'
, 3
, 'SUPPLY SCHEDULE ITEMS ONLY'
, 4
, 'DEMAND
AND SUPPLY SCHEDULE ITEMS')
, NVL(PP.CURR_SR_ASSIGNMENT_SET
, ' ')
, NVL(PP.CURR_DEM_PRIORITY_RULE
, ' ')
, DECODE(PP.CURR_OPERATION_SCHEDULE_TYPE
, 1
, 'OPERATION START DATE'
, 2
, 'ORDER START DATE')
, DECODE(PP.CURR_APPEND_PLANNED_ORDERS
, 1
, 'YES'
, 2
, 'NO')
, DECODE(PP.CURR_FULL_PEGGING
, 1
, 'YES'
, 2
, 'NO')
, DECODE(PP.CURR_DEMAND_TIME_FENCE_FLAG
, 1
, 'YES'
, 2
, 'NO')
, DECODE(PP.CURR_PLANNING_TIME_FENCE_FLAG
, 1
, 'YES'
, 2
, 'NO')
, DECODE(PP.LOT_FOR_LOT
, 1
, 'YES'
, 2
, 'NO')
, PP.COMPILE_DESIGNATOR
, TO_CHAR(PP.CURR_CUTOFF_DATE)
, DECODE(PP.OPTIMIZE_FLAG
, 1
, 'YES'
, 2
, 'NO')
, DECODE(PP.CURR_ENFORCE_CAP_CONSTRAINTS
, 1
, 'YES'
, 2
, 'NO')
, DECODE(PP.CURR_ENFORCE_DEM_DUE_DATES
, 1
, 'YES'
, 2
, 'NO')
, NVL(PP.OBJECTIVE_WEIGHT_1
, 0)
, NVL(PP.OBJECTIVE_WEIGHT_2
, 0)
, NVL(PP.OBJECTIVE_WEIGHT_4
, 0)
, NVL(PP.SUPPLIER_CAP_OVER_UTIL_COST
, 0)
, NVL(PP.RESOURCE_OVER_UTIL_COST
, 0)
, NVL(PP.TRANSPORT_CAP_OVER_UTIL_COST
, 0)
, NVL(PP.DMD_LATENESS_PENALTY_COST
, 0)
, NVL(PP.DAILY_CUTOFF_BUCKET
, 0)
, DECODE(PP.DAILY_ITEM_AGGREGATION_LEVEL
, 1
, 'ITEMS'
, 2
, 'PRODUCT FAMILY')
, DECODE(PP.DAILY_RES_AGGREGATION_LEVEL
, 1
, 'INDIVIDUAL'
, 2
, 'AGGREGATE')
, DECODE(PP.DAILY_RTG_AGGREGATION_LEVEL
, 1
, 'ROUTINGS'
, 2
, 'BOR')
, DECODE(PP.DAILY_RESOURCE_CONSTRAINTS
, 1
, 'YES'
, 2
, 'NO')
, DECODE(PP.DAILY_MATERIAL_CONSTRAINTS
, 1
, 'YES'
, 2
, 'NO')
, NVL(PP.WEEKLY_CUTOFF_BUCKET
, 0)
, DECODE(PP.WEEKLY_ITEM_AGGREGATION_LEVEL
, 1
, 'ITEMS'
, 2
, 'PRODUCT FAMILY')
, DECODE(PP.WEEKLY_RES_AGGREGATION_LEVEL
, 1
, 'INDIVIDUAL'
, 2
, 'AGGREGATE')
, DECODE(PP.WEEKLY_RTG_AGGREGATION_LEVEL
, 1
, 'ROUTINGS'
, 2
, 'BOR')
, DECODE(PP.WEEKLY_RESOURCE_CONSTRAINTS
, 1
, 'YES'
, 2
, 'NO')
, DECODE(PP.WEEKLY_MATERIAL_CONSTRAINTS
, 1
, 'YES'
, 2
, 'NO')
, NVL(PP.PERIOD_CUTOFF_BUCKET
, 0)
, DECODE(PP.PERIOD_ITEM_AGGREGATION_LEVEL
, 1
, 'ITEMS'
, 2
, 'PRODUCT FAMILY')
, DECODE(PP.PERIOD_RES_AGGREGATION_LEVEL
, 1
, 'INDIVIDUAL'
, 2
, 'AGGREGATE')
, DECODE(PP.PERIOD_RTG_AGGREGATION_LEVEL
, 1
, 'ROUTINGS'
, 2
, 'BOR')
, DECODE(PP.PERIOD_RESOURCE_CONSTRAINTS
, 1
, 'YES'
, 2
, 'NO')
, DECODE(PP.PERIOD_MATERIAL_CONSTRAINTS
, 1
, 'YES'
, 2
, 'NO')
, TO_CHAR(NULL)
, PP.COMPILE_DESIGNATOR
, TO_CHAR(TRUNC(SYSDATE))
, PP.PLAN_ID
, PP.ORGANIZATION_ID
, PP.SR_INSTANCE_ID
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, TO_CHAR(PP.CURR_START_DATE)
, DECODE(PP.USE_END_ITEM_SUBSTITUTIONS
, NULL
, 'NO'
, 1
, 'YES'
, 2
, 'NO')
, DECODE(PP.USE_ALTERNATE_RESOURCES
, NULL
, 'YES'
, 1
, 'YES'
, 2
, 'NO')
, DECODE(PP.USE_ALTERNATE_BOM_ROUTING
, NULL
, 'YES'
, 1
, 'YES'
, 2
, 'NO')
, DECODE(PP.USE_SUBSTITUTE_COMPONENTS
, NULL
, 'YES'
, 1
, 'YES'
, 2
, 'NO')
, DECODE(PP.USE_ALTERNATE_SOURCES
, NULL
, 'YES'
, 1
, 'YES'
, 2
, 'NO')
, PP.SUBSTITUTION_SET
, PP.CURR_PLAN_TYPE
, DECODE(PP.CURR_HARD_PEGGING_LEVEL
, NULL
, 'NONE'
, 1
, 'PROJECT'
, 2
, 'PROJECT-TASK'
, 3
, 'NONE')
, DECODE(PP.CURR_RESERVATION_LEVEL
, NULL
, 'NONE'
, 1
, 'PLANNING GROUP '
, 2
, 'PROJECT '
, 3
, 'PROJECT-TASK '
, 4
, 'NONE ')
, DECODE(PP.CURR_ENABLE_CLOSEST_QTY_PEG
, NULL
, 'NO'
, 1
, 'YES'
, 2
, 'NO')
, DECODE(PP.CURR_ENABLE_PRIORITY_PEGGING
, NULL
, 'NO'
, 1
, 'YES'
, 2
, 'NO')
FROM MSC_PDR_PARAMETERS_NEW PARM2
, MSC_PLANS XPP
, MSC_PLAN_PARAMETERS_V PP
WHERE XPP.PLAN_ID = PARM2.NUMBER1
AND PARM2.USER_ID = FND_GLOBAL.USER_ID
AND PARM2.PARM_TYPE = 2
AND PP.PLAN_ID = XPP.PLAN_ID
AND PP.ORGANIZATION_ID = XPP.ORGANIZATION_ID
AND PP.SR_INSTANCE_ID = XPP.SR_INSTANCE_ID
AND PP.COMPILE_DESIGNATOR = XPP.COMPILE_DESIGNATOR