Product: | MRP - Master Scheduling/MRP |
---|---|
Description: | MRP or MPS plan options view |
Implementation/DBA Data: | APPS.MRP_PLANS_SC_V |
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