Product: | MRP - Master Scheduling/MRP |
---|---|
Description: | MRP Plan Options View |
Implementation/DBA Data: | APPS.MRP_PLAN_ORGS_V |
SELECT MPO.ROWID
, MPO.ORGANIZATION_ID
, MPO.COMPILE_DESIGNATOR
, MPO.PLANNED_ORGANIZATION
, PARAM.ORGANIZATION_CODE
, ORGS.NAME
, MPO.PLAN_LEVEL
, MPO.LAST_UPDATED_BY
, MPO.LAST_UPDATE_DATE
, MPO.CREATED_BY
, MPO.CREATION_DATE
, MPO.LAST_UPDATE_LOGIN
, MPO.NET_WIP
, MPO.NET_RESERVATIONS
, MPO.NET_PURCHASING
, MPO.PLAN_SAFETY_STOCK
, MPO.REQUEST_ID
, MPO.PROGRAM_APPLICATION_ID
, MPO.PROGRAM_ID
, MPO.PROGRAM_UPDATE_DATE
, MPO.ATTRIBUTE_CATEGORY
, MPO.ATTRIBUTE1
, MPO.ATTRIBUTE2
, MPO.ATTRIBUTE3
, MPO.ATTRIBUTE4
, MPO.ATTRIBUTE5
, MPO.ATTRIBUTE6
, MPO.ATTRIBUTE7
, MPO.ATTRIBUTE8
, MPO.ATTRIBUTE9
, MPO.ATTRIBUTE10
, MPO.ATTRIBUTE11
, MPO.ATTRIBUTE12
, MPO.ATTRIBUTE13
, MPO.ATTRIBUTE14
, MPO.ATTRIBUTE15
, MPO.SIMULATION_SET
, MPO.BILL_OF_RESOURCES
FROM HR_ORGANIZATION_UNITS ORGS
, MTL_PARAMETERS PARAM
, MRP_PARAMETERS MRP
, MRP_PLAN_ORGANIZATIONS MPO
WHERE ORGS.ORGANIZATION_ID = PARAM.ORGANIZATION_ID
AND PARAM.ORGANIZATION_ID = MRP.ORGANIZATION_ID
AND MRP.ORGANIZATION_ID = MPO.PLANNED_ORGANIZATION