Product: | CRP - Capacity |
---|---|
Description: | View of resources used for a plan |
Implementation/DBA Data: | APPS.CRP_PLANNED_RESOURCES_V |
SELECT RES.ROWID
, RES.ORGANIZATION_ID
, MTL.ORGANIZATION_CODE
, RES.COMPILE_DESIGNATOR
, RES.OWNING_DEPARTMENT_ID
, OWNING.DEPARTMENT_CODE
, RES.DEPARTMENT_ID
, NVL(USING.DEPARTMENT_CODE
, LINES.LINE_CODE)
, NVL(USING.DESCRIPTION
, LINES.DESCRIPTION)
, USING.DEPARTMENT_CLASS_CODE
, RES.RESOURCE_ID
, BOM_RES.RESOURCE_CODE
, BOM_RES.RESOURCE_TYPE
, LKPS.MEANING
, BOM_DEPT_RES.RESOURCE_GROUP_NAME
, RES.LINE_ID
, LINES.MAXIMUM_RATE
, LINES.MINIMUM_RATE
, RES.RESOURCE_SHORTAGE_TYPE
, RES.RESOURCE_EXCESS_TYPE
, RES.OVERUTILIZED_PERCENT
, RES.UNDERUTILIZED_PERCENT
, RES.MAX_UTILIZATION
, RES.MIN_UTILIZATION
, RES.UTILIZATION
, RES.EFFICIENCY
, RES.LAST_UPDATE_DATE
, RES.LAST_UPDATED_BY
, RES.CREATION_DATE
, RES.CREATED_BY
, RES.LAST_UPDATE_LOGIN
, RES.ATTRIBUTE_CATEGORY
, RES.ATTRIBUTE1
, RES.ATTRIBUTE2
, RES.ATTRIBUTE3
, RES.ATTRIBUTE4
, RES.ATTRIBUTE5
, RES.ATTRIBUTE6
, RES.ATTRIBUTE7
, RES.ATTRIBUTE8
, RES.ATTRIBUTE9
, RES.ATTRIBUTE10
, RES.ATTRIBUTE11
, RES.ATTRIBUTE12
, RES.ATTRIBUTE13
, RES.ATTRIBUTE14
, RES.ATTRIBUTE15
, DECODE(RES.RESOURCE_ID
, -1
, LINES.DISABLE_DATE
, BOM_RES.DISABLE_DATE)
FROM MTL_PARAMETERS MTL
, WIP_LINES LINES
, MFG_LOOKUPS LKPS
, BOM_DEPARTMENT_RESOURCES BOM_DEPT_RES
, BOM_DEPARTMENTS OWNING
, BOM_DEPARTMENTS USING
, BOM_RESOURCES BOM_RES
, CRP_PLANNED_RESOURCES RES
WHERE MTL.ORGANIZATION_ID = RES.ORGANIZATION_ID
AND LINES.LINE_ID (+) = RES.LINE_ID
AND LKPS.LOOKUP_TYPE (+) = 'BOM_RESOURCE_TYPE'
AND LKPS.LOOKUP_CODE(+) = BOM_RES.RESOURCE_TYPE
AND BOM_RES.RESOURCE_ID (+) = RES.RESOURCE_ID
AND BOM_DEPT_RES.DEPARTMENT_ID (+)= RES.DEPARTMENT_ID
AND BOM_DEPT_RES.RESOURCE_ID (+) = RES.RESOURCE_ID
AND OWNING.DEPARTMENT_ID (+) = RES.OWNING_DEPARTMENT_ID
AND USING.DEPARTMENT_ID (+) = RES.DEPARTMENT_ID