eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: CRP_AVAILABLE_RESOURCES_V

Product:	CRP - Capacity
Description:	View of resource availability
Implementation/DBA Data:	APPS.CRP_AVAILABLE_RESOURCES_V

View Text

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

Columns

Name
ROW_ID
ORGANIZATION_ID
ORGANIZATION_CODE
COMPILE_DESIGNATOR
LINE_ID
DEPARTMENT_ID
DEPT_LINE_CODE
DEPT_LINE_DESC
RESOURCE_ID
RESOURCE_CODE
RESOURCE_DESC
RESOURCE_START_DATE
RESOURCE_END_DATE
RESOURCE_HOURS
RESOURCE_UNITS
TOTAL_AVAILABILITY
UOM
MAX_RATE
UPDATED
STATUS
APPLIED
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15