VIEW: APPS.MRP_PLAN_ORGS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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