VIEW: APPS.CRP_AVAILABLE_RESOURCES_V

Source

View Text - Preformatted

SELECT RES.ROWID , RES.ORGANIZATION_ID , MTL.ORGANIZATION_CODE , RES.COMPILE_DESIGNATOR , RES.LINE_ID , RES.DEPARTMENT_ID , BOM_DEPT.DEPARTMENT_CODE , BOM_DEPT.DESCRIPTION , RES.RESOURCE_ID , BOM_RES.RESOURCE_CODE , BOM_RES.DESCRIPTION , RES.RESOURCE_START_DATE , RES.RESOURCE_END_DATE , RES.RESOURCE_HOURS , RES.RESOURCE_UNITS , RES.RESOURCE_HOURS * RES.RESOURCE_UNITS , FND_PROFILE.VALUE('BOM:HOUR_UOM_CODE') , RES.MAX_RATE , RES.UPDATED , RES.STATUS , RES.APPLIED , 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 FROM MTL_PARAMETERS MTL, BOM_RESOURCES BOM_RES, BOM_DEPARTMENTS BOM_DEPT, CRP_AVAILABLE_RESOURCES RES WHERE MTL.ORGANIZATION_ID = RES.ORGANIZATION_ID AND BOM_RES.RESOURCE_ID = RES.RESOURCE_ID AND BOM_DEPT.DEPARTMENT_ID = RES.DEPARTMENT_ID AND RES.DEPARTMENT_ID IS NOT NULL UNION ALL SELECT RES.ROWID , RES.ORGANIZATION_ID , MTL.ORGANIZATION_CODE , RES.COMPILE_DESIGNATOR , RES.LINE_ID , RES.DEPARTMENT_ID , LINES.LINE_CODE , LINES.DESCRIPTION , RES.RESOURCE_ID , NULL , NULL , RES.RESOURCE_START_DATE , RES.RESOURCE_END_DATE , RES.RESOURCE_HOURS , RES.RESOURCE_UNITS , RES.MAX_RATE , NULL , RES.MAX_RATE , RES.UPDATED , RES.STATUS , RES.APPLIED , 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 FROM MTL_PARAMETERS MTL, WIP_LINES LINES, CRP_AVAILABLE_RESOURCES RES WHERE MTL.ORGANIZATION_ID = RES.ORGANIZATION_ID AND LINES.LINE_ID = RES.LINE_ID AND RES.LINE_ID IS NOT NULL

View Text - HTML Formatted

SELECT RES.ROWID
, RES.ORGANIZATION_ID
, MTL.ORGANIZATION_CODE
, RES.COMPILE_DESIGNATOR
, RES.LINE_ID
, RES.DEPARTMENT_ID
, BOM_DEPT.DEPARTMENT_CODE
, BOM_DEPT.DESCRIPTION
, RES.RESOURCE_ID
, BOM_RES.RESOURCE_CODE
, BOM_RES.DESCRIPTION
, RES.RESOURCE_START_DATE
, RES.RESOURCE_END_DATE
, RES.RESOURCE_HOURS
, RES.RESOURCE_UNITS
, RES.RESOURCE_HOURS * RES.RESOURCE_UNITS
, FND_PROFILE.VALUE('BOM:HOUR_UOM_CODE')
, RES.MAX_RATE
, RES.UPDATED
, RES.STATUS
, RES.APPLIED
, 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
FROM MTL_PARAMETERS MTL
, BOM_RESOURCES BOM_RES
, BOM_DEPARTMENTS BOM_DEPT
, CRP_AVAILABLE_RESOURCES RES
WHERE MTL.ORGANIZATION_ID = RES.ORGANIZATION_ID
AND BOM_RES.RESOURCE_ID = RES.RESOURCE_ID
AND BOM_DEPT.DEPARTMENT_ID = RES.DEPARTMENT_ID
AND RES.DEPARTMENT_ID IS NOT NULL UNION ALL SELECT RES.ROWID
, RES.ORGANIZATION_ID
, MTL.ORGANIZATION_CODE
, RES.COMPILE_DESIGNATOR
, RES.LINE_ID
, RES.DEPARTMENT_ID
, LINES.LINE_CODE
, LINES.DESCRIPTION
, RES.RESOURCE_ID
, NULL
, NULL
, RES.RESOURCE_START_DATE
, RES.RESOURCE_END_DATE
, RES.RESOURCE_HOURS
, RES.RESOURCE_UNITS
, RES.MAX_RATE
, NULL
, RES.MAX_RATE
, RES.UPDATED
, RES.STATUS
, RES.APPLIED
, 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
FROM MTL_PARAMETERS MTL
, WIP_LINES LINES
, CRP_AVAILABLE_RESOURCES RES
WHERE MTL.ORGANIZATION_ID = RES.ORGANIZATION_ID
AND LINES.LINE_ID = RES.LINE_ID
AND RES.LINE_ID IS NOT NULL