Product: | MRP - Master Scheduling/MRP |
---|---|
Description: | Plan options view |
Implementation/DBA Data: | APPS.MRP_PLAN_SCHED_V |
SELECT /*+ (INDEX MRP_DESIGNATORS_U1 MRP_DESIGNATORS) */ MPS.ROWID
, MPS.ORGANIZATION_ID
, MPS.COMPILE_DESIGNATOR
, MPS.PLAN_LEVEL
, NVL(MPO.PLANNED_ORGANIZATION
, MPS.INPUT_ORGANIZATION_ID)
, DESIG.DESIGNATOR
, MPS.LAST_UPDATE_DATE
, MPS.LAST_UPDATED_BY
, MPS.CREATION_DATE
, MPS.CREATED_BY
, MPS.LAST_UPDATE_LOGIN
, MPS.INPUT_TYPE
, LU.MEANING
, DESIG.DESCRIPTION
, MPS.REQUEST_ID
, MPS.PROGRAM_APPLICATION_ID
, MPS.PROGRAM_ID
, MPS.PROGRAM_UPDATE_DATE
, MPS.ATTRIBUTE_CATEGORY
, MPS.ATTRIBUTE1
, MPS.ATTRIBUTE2
, MPS.ATTRIBUTE3
, MPS.ATTRIBUTE4
, MPS.ATTRIBUTE5
, MPS.ATTRIBUTE6
, MPS.ATTRIBUTE7
, MPS.ATTRIBUTE8
, MPS.ATTRIBUTE9
, MPS.ATTRIBUTE10
, MPS.ATTRIBUTE11
, MPS.ATTRIBUTE12
, MPS.ATTRIBUTE13
, MPS.ATTRIBUTE14
, MPS.ATTRIBUTE15
FROM MFG_LOOKUPS LU
, MRP_DESIGNATORS_VIEW DESIG
, MRP_PLAN_ORGANIZATIONS_V MPO
, MRP_PLAN_SCHEDULES MPS
WHERE LU.LOOKUP_TYPE = 'MRP_DESIGNATOR_TYPE_SHORT'
AND LU.LOOKUP_CODE = MPS.INPUT_TYPE
AND DESIG.ORGANIZATION_ID = NVL(MPO.ORGANIZATION_ID
, MPS.INPUT_ORGANIZATION_ID)
AND DESIG.DESIGNATOR = NVL(MPO.COMPILE_DESIGNATOR
, MPS.INPUT_NAME)
AND MPO.PLANNED_ORGANIZATION (+) = MPS.INPUT_ORGANIZATION_ID
AND MPO.COMPILE_DESIGNATOR (+) = MPS.INPUT_NAME