VIEW: APPS.CRP_PLANNED_RESOURCES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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