VIEW: APPS.MRP_PLAN_PARAMETERS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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