VIEW: APPS.MRP_PLANS_SC_V

Source

View Text - Preformatted

SELECT M.ROWID , MD.ORGANIZATION_ID , MTL.ORGANIZATION_CODE , MD.DESIGNATOR , M.LAST_UPDATE_DATE , M.LAST_UPDATED_BY , M.CREATION_DATE , M.CREATED_BY , M.LAST_UPDATE_LOGIN , M.CURR_SCHEDULE_DESIGNATOR , MS.DESCRIPTION , M.CURR_OPERATION_SCHEDULE_TYPE , M.CURR_PLAN_TYPE , L1.MEANING , M.CURR_OVERWRITE_OPTION , M.CURR_APPEND_PLANNED_ORDERS , M.CURR_SCHEDULE_TYPE , L2.MEANING , M.CURR_CUTOFF_DATE , M.CURR_PART_INCLUDE_TYPE , M.CURR_PLANNING_TIME_FENCE_FLAG , M.CURR_DEMAND_TIME_FENCE_FLAG , M.CURR_CONSIDER_RESERVATIONS , M.CURR_PLAN_SAFETY_STOCK , M.CURR_CONSIDER_WIP , M.CURR_CONSIDER_PO , M.CURR_SNAPSHOT_LOCK , M.COMPILE_DEFINITION_DATE , M.SCHEDULE_DESIGNATOR , MS2.DESCRIPTION , M.OPERATION_SCHEDULE_TYPE , M.PLAN_TYPE ,L1.MEANING , M.OVERWRITE_OPTION , M.APPEND_PLANNED_ORDERS , M.SCHEDULE_TYPE , L3.MEANING , 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.EXPLOSION_START_DATE , M.EXPLOSION_COMPLETION_DATE , M.DATA_START_DATE , M.DATA_COMPLETION_DATE , M.PLAN_START_DATE , M.CRP_PLAN_COMPLETION_DATE , M.PLAN_COMPLETION_DATE , M.CRP_PLAN_START_DATE , M.CURRENT_PLANNER_LEVEL , M.PLANNER_BATCH_NUMBER , MD.DESCRIPTION , M.UPDATE_BOM , M.DEMAND_CLASS , M.REQUEST_ID , M.PROGRAM_APPLICATION_ID , M.PROGRAM_ID , M.PROGRAM_UPDATE_DATE , M.ATTRIBUTE_CATEGORY , M.ATTRIBUTE1 , M.ATTRIBUTE2 , M.ATTRIBUTE3 , M.ATTRIBUTE4 , M.ATTRIBUTE5 , M.ATTRIBUTE6 , M.ATTRIBUTE7 , M.ATTRIBUTE8 , M.ATTRIBUTE9 , M.ATTRIBUTE10 , M.ATTRIBUTE11 , M.ATTRIBUTE12 , M.ATTRIBUTE13 , M.ATTRIBUTE14 , M.ATTRIBUTE15 , MD.DISABLE_DATE , NVL( M.USE_NEW_PLANNER,2) , NVL(M.CURR_FULL_PEGGING,2) , NVL(M.FULL_PEGGING,2) , NVL(M.ORGANIZATION_SELECTION, 1) , L4.MEANING , ORG.PLANNED_ORGANIZATION , M.CURR_RESERVATION_LEVEL , NVL(M.CURR_PLAN_CAPACITY_FLAG,2) , M.CURR_SIMULATION_SET , M.CURR_BILL_OF_RESOURCES , NVL(M.PLAN_CAPACITY_FLAG,2) , M.SIMULATION_SET , M.BILL_OF_RESOURCES , NVL(MD.PRODUCTION, 2) FROM MFG_LOOKUPS L1, MFG_LOOKUPS L2, MFG_LOOKUPS L3, MFG_LOOKUPS L4, MRP_SCHEDULE_DESIGNATORS MS, MRP_SCHEDULE_DESIGNATORS MS2, MTL_PARAMETERS MTL, MRP_ORGANIZATIONS_V ORG, MRP_PLANS M, MRP_DESIGNATORS_VIEW MD WHERE L1.LOOKUP_TYPE = 'MRP_PLAN_TYPE' AND L1.LOOKUP_CODE = M.PLAN_TYPE AND MS2.ORGANIZATION_ID(+) = M.ORGANIZATION_ID AND MS2.SCHEDULE_DESIGNATOR(+) = M.SCHEDULE_DESIGNATOR AND L3.LOOKUP_TYPE(+) = 'MRP_DESIGNATOR_TYPE_SHORT' AND L3.LOOKUP_CODE(+) = M.SCHEDULE_TYPE AND L4.LOOKUP_TYPE(+) = 'MRP_ORGANIZATION_SELECTION' AND L4.LOOKUP_CODE(+) = NVL(M.ORGANIZATION_SELECTION, 1) AND MS.ORGANIZATION_ID(+) = M.ORGANIZATION_ID AND MS.SCHEDULE_DESIGNATOR(+) = M.CURR_SCHEDULE_DESIGNATOR AND MS.SCHEDULE_TYPE(+) = M.CURR_SCHEDULE_TYPE AND L2.LOOKUP_TYPE(+) = 'MRP_DESIGNATOR_TYPE_SHORT' AND L2.LOOKUP_CODE(+) = M.CURR_SCHEDULE_TYPE AND MTL.ORGANIZATION_ID = M.ORGANIZATION_ID AND ORG.ORGANIZATION_ID = M.ORGANIZATION_ID AND ORG.COMPILE_DESIGNATOR = M.COMPILE_DESIGNATOR AND MD.DESIGNATOR = M.COMPILE_DESIGNATOR AND MD.ORGANIZATION_ID = M.ORGANIZATION_ID

View Text - HTML Formatted

SELECT M.ROWID
, MD.ORGANIZATION_ID
, MTL.ORGANIZATION_CODE
, MD.DESIGNATOR
, M.LAST_UPDATE_DATE
, M.LAST_UPDATED_BY
, M.CREATION_DATE
, M.CREATED_BY
, M.LAST_UPDATE_LOGIN
, M.CURR_SCHEDULE_DESIGNATOR
, MS.DESCRIPTION
, M.CURR_OPERATION_SCHEDULE_TYPE
, M.CURR_PLAN_TYPE
, L1.MEANING
, M.CURR_OVERWRITE_OPTION
, M.CURR_APPEND_PLANNED_ORDERS
, M.CURR_SCHEDULE_TYPE
, L2.MEANING
, M.CURR_CUTOFF_DATE
, M.CURR_PART_INCLUDE_TYPE
, M.CURR_PLANNING_TIME_FENCE_FLAG
, M.CURR_DEMAND_TIME_FENCE_FLAG
, M.CURR_CONSIDER_RESERVATIONS
, M.CURR_PLAN_SAFETY_STOCK
, M.CURR_CONSIDER_WIP
, M.CURR_CONSIDER_PO
, M.CURR_SNAPSHOT_LOCK
, M.COMPILE_DEFINITION_DATE
, M.SCHEDULE_DESIGNATOR
, MS2.DESCRIPTION
, M.OPERATION_SCHEDULE_TYPE
, M.PLAN_TYPE
, L1.MEANING
, M.OVERWRITE_OPTION
, M.APPEND_PLANNED_ORDERS
, M.SCHEDULE_TYPE
, L3.MEANING
, 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.EXPLOSION_START_DATE
, M.EXPLOSION_COMPLETION_DATE
, M.DATA_START_DATE
, M.DATA_COMPLETION_DATE
, M.PLAN_START_DATE
, M.CRP_PLAN_COMPLETION_DATE
, M.PLAN_COMPLETION_DATE
, M.CRP_PLAN_START_DATE
, M.CURRENT_PLANNER_LEVEL
, M.PLANNER_BATCH_NUMBER
, MD.DESCRIPTION
, M.UPDATE_BOM
, M.DEMAND_CLASS
, M.REQUEST_ID
, M.PROGRAM_APPLICATION_ID
, M.PROGRAM_ID
, M.PROGRAM_UPDATE_DATE
, M.ATTRIBUTE_CATEGORY
, M.ATTRIBUTE1
, M.ATTRIBUTE2
, M.ATTRIBUTE3
, M.ATTRIBUTE4
, M.ATTRIBUTE5
, M.ATTRIBUTE6
, M.ATTRIBUTE7
, M.ATTRIBUTE8
, M.ATTRIBUTE9
, M.ATTRIBUTE10
, M.ATTRIBUTE11
, M.ATTRIBUTE12
, M.ATTRIBUTE13
, M.ATTRIBUTE14
, M.ATTRIBUTE15
, MD.DISABLE_DATE
, NVL( M.USE_NEW_PLANNER
, 2)
, NVL(M.CURR_FULL_PEGGING
, 2)
, NVL(M.FULL_PEGGING
, 2)
, NVL(M.ORGANIZATION_SELECTION
, 1)
, L4.MEANING
, ORG.PLANNED_ORGANIZATION
, M.CURR_RESERVATION_LEVEL
, NVL(M.CURR_PLAN_CAPACITY_FLAG
, 2)
, M.CURR_SIMULATION_SET
, M.CURR_BILL_OF_RESOURCES
, NVL(M.PLAN_CAPACITY_FLAG
, 2)
, M.SIMULATION_SET
, M.BILL_OF_RESOURCES
, NVL(MD.PRODUCTION
, 2)
FROM MFG_LOOKUPS L1
, MFG_LOOKUPS L2
, MFG_LOOKUPS L3
, MFG_LOOKUPS L4
, MRP_SCHEDULE_DESIGNATORS MS
, MRP_SCHEDULE_DESIGNATORS MS2
, MTL_PARAMETERS MTL
, MRP_ORGANIZATIONS_V ORG
, MRP_PLANS M
, MRP_DESIGNATORS_VIEW MD
WHERE L1.LOOKUP_TYPE = 'MRP_PLAN_TYPE'
AND L1.LOOKUP_CODE = M.PLAN_TYPE
AND MS2.ORGANIZATION_ID(+) = M.ORGANIZATION_ID
AND MS2.SCHEDULE_DESIGNATOR(+) = M.SCHEDULE_DESIGNATOR
AND L3.LOOKUP_TYPE(+) = 'MRP_DESIGNATOR_TYPE_SHORT'
AND L3.LOOKUP_CODE(+) = M.SCHEDULE_TYPE
AND L4.LOOKUP_TYPE(+) = 'MRP_ORGANIZATION_SELECTION'
AND L4.LOOKUP_CODE(+) = NVL(M.ORGANIZATION_SELECTION
, 1)
AND MS.ORGANIZATION_ID(+) = M.ORGANIZATION_ID
AND MS.SCHEDULE_DESIGNATOR(+) = M.CURR_SCHEDULE_DESIGNATOR
AND MS.SCHEDULE_TYPE(+) = M.CURR_SCHEDULE_TYPE
AND L2.LOOKUP_TYPE(+) = 'MRP_DESIGNATOR_TYPE_SHORT'
AND L2.LOOKUP_CODE(+) = M.CURR_SCHEDULE_TYPE
AND MTL.ORGANIZATION_ID = M.ORGANIZATION_ID
AND ORG.ORGANIZATION_ID = M.ORGANIZATION_ID
AND ORG.COMPILE_DESIGNATOR = M.COMPILE_DESIGNATOR
AND MD.DESIGNATOR = M.COMPILE_DESIGNATOR
AND MD.ORGANIZATION_ID = M.ORGANIZATION_ID