View: MRP_PLAN_PARAMETERS_V

Product:	MRP - Master Scheduling/MRP
Description:	MRP or MPS Plan Options View
Implementation/DBA Data:	APPS.MRP_PLAN_PARAMETERS_V

View Text

SELECT M.ROWID
, D.ORGANIZATION_ID
, NVL(MPO.PLANNED_ORGANIZATION
, D.ORGANIZATION_ID)
, D.DESIGNATOR
, NVL(M.LAST_UPDATE_DATE
, SYSDATE)
, NVL(M.LAST_UPDATED_BY
, D.LAST_UPDATED_BY)
, NVL(M.CREATION_DATE
, SYSDATE)
, NVL(M.CREATED_BY
, D.CREATED_BY)
, M.LAST_UPDATE_LOGIN
, M.CURR_SCHEDULE_DESIGNATOR
, S1.DESCRIPTION
, NVL(M.CURR_OPERATION_SCHEDULE_TYPE
, P.OPERATION_SCHEDULE_TYPE)
, DECODE(D.DESIGNATOR_TYPE
, 2
, 2
, 3
, 1
, 3)
, MRP_GET_PROJECT.LOOKUP_MEANING('MRP_PLAN_TYPE'
, DECODE(D.DESIGNATOR_TYPE
, 2
, 2
, 3
, 1
, 3))
, NVL(M.CURR_OVERWRITE_OPTION
, 1)
, NVL(M.CURR_APPEND_PLANNED_ORDERS
, DECODE(M.CURR_OVERWRITE_OPTION
, 3
, 2
, 1))
, M.CURR_SCHEDULE_TYPE
, MRP_GET_PROJECT.LOOKUP_MEANING('MRP_DESIGNATOR_TYPE_SHORT'
, M.CURR_SCHEDULE_TYPE)
, P.REPETITIVE_ANCHOR_DATE
, NVL(M.CURR_CUTOFF_DATE
, SYSDATE)
, NVL(M.CURR_PART_INCLUDE_TYPE
, P.PART_INCLUDE_TYPE)
, NVL(M.CURR_PLANNING_TIME_FENCE_FLAG
, P.PLANNING_TIME_FENCE_FLAG)
, NVL(M.CURR_DEMAND_TIME_FENCE_FLAG
, P.DEMAND_TIME_FENCE_FLAG)
, NVL(M.CURR_CONSIDER_RESERVATIONS
, P.CONSIDER_RESERVATIONS)
, NVL(M.CURR_PLAN_SAFETY_STOCK
, P.PLAN_SAFETY_STOCK)
, NVL(M.CURR_CONSIDER_WIP
, P.CONSIDER_WIP)
, NVL(M.CURR_CONSIDER_PO
, P.CONSIDER_PO)
, NVL(M.CURR_SNAPSHOT_LOCK
, P.SNAPSHOT_LOCK)
, NVL(M.COMPILE_DEFINITION_DATE
, SYSDATE)
, D.DESCRIPTION
, D.USE_NEW_PLANNER
, D.DISABLE_DATE
, NVL(M.CURR_FULL_PEGGING
, 2)
, M.CURR_ASSIGNMENT_SET_ID
, MAS.ASSIGNMENT_SET_NAME
, MAS.DESCRIPTION
, NVL(D.ORGANIZATION_SELECTION
, 1)
, MRP_GET_PROJECT.LOOKUP_MEANING('MRP_ORGANIZATION_SELECTION'
, NVL(D.ORGANIZATION_SELECTION
, 1))
, M.SCHEDULE_DESIGNATOR
, S2.DESCRIPTION
, M.OPERATION_SCHEDULE_TYPE
, M.PLAN_TYPE
, MRP_GET_PROJECT.LOOKUP_MEANING('MRP_PLAN_TYPE'
, M.PLAN_TYPE)
, M.OVERWRITE_OPTION
, M.APPEND_PLANNED_ORDERS
, M.SCHEDULE_TYPE
, MRP_GET_PROJECT.LOOKUP_MEANING('MRP_DESIGNATOR_TYPE_SHORT'
, M.SCHEDULE_TYPE)
, M.CUTOFF_DATE
, M.PART_INCLUDE_TYPE
, M.PLANNING_TIME_FENCE_FLAG
, M.DEMAND_TIME_FENCE_FLAG
, M.CONSIDER_RESERVATIONS
, M.PLAN_SAFETY_STOCK
, M.CONSIDER_WIP
, M.CONSIDER_PO
, M.SNAPSHOT_LOCK
, M.ASSIGNMENT_SET_ID
, MAS1.ASSIGNMENT_SET_NAME
, MAS1.DESCRIPTION
, M.FULL_PEGGING
, M.EXPLOSION_START_DATE
, M.EXPLOSION_COMPLETION_DATE
, M.DATA_START_DATE
, M.DATA_COMPLETION_DATE
, M.PLAN_START_DATE
, M.PLAN_COMPLETION_DATE
, M.CRP_PLAN_START_DATE
, M.CRP_PLAN_COMPLETION_DATE
, NVL(M.CURR_RESERVATION_LEVEL
, 4)
, NVL(M.CURR_HARD_PEGGING_LEVEL
, 3)
, NVL(M.RESERVATION_LEVEL
, 3)
, NVL(M.HARD_PEGGING_LEVEL
, 3)
, NVL(M.CURR_PLAN_CAPACITY_FLAG
, 2)
, M.CURR_SIMULATION_SET
, M.CURR_BILL_OF_RESOURCES
, M.PLAN_CAPACITY_FLAG
, M.SIMULATION_SET
, M.BILL_OF_RESOURCES
FROM MRP_SCHEDULE_DESIGNATORS S1
, MRP_SCHEDULE_DESIGNATORS S2
, MRP_PARAMETERS P
, MRP_ASSIGNMENT_SETS MAS
, MRP_ASSIGNMENT_SETS MAS1
, MRP_ORGANIZATIONS_V MPO
, MRP_PLANS M
, MRP_DESIGNATORS_VIEW D
WHERE S1.SCHEDULE_DESIGNATOR(+) = M.CURR_SCHEDULE_DESIGNATOR
AND S1.ORGANIZATION_ID(+) = M.ORGANIZATION_ID
AND S2.SCHEDULE_DESIGNATOR (+) = M.SCHEDULE_DESIGNATOR
AND S2.ORGANIZATION_ID(+) = M.ORGANIZATION_ID
AND P.ORGANIZATION_ID = D.ORGANIZATION_ID
AND MAS1.ASSIGNMENT_SET_ID (+) = M.ASSIGNMENT_SET_ID
AND MAS.ASSIGNMENT_SET_ID (+) = M.CURR_ASSIGNMENT_SET_ID
AND MPO.ORGANIZATION_ID (+) = M.ORGANIZATION_ID
AND MPO.COMPILE_DESIGNATOR (+) = M.COMPILE_DESIGNATOR
AND D.DESIGNATOR_TYPE IN (2
, 3
, 4)
AND M.ORGANIZATION_ID(+) = D.ORGANIZATION_ID
AND M.COMPILE_DESIGNATOR(+) = D.DESIGNATOR

Columns