View: MSC_PDR_PLAN_DETAILS_V1

Product:	MSC - Advanced Supply Chain Planning
Description:
Implementation/DBA Data:	APPS.MSC_PDR_PLAN_DETAILS_V1

View Text

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

Columns