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: MRP_RHX_BOM_RESOURCE_CAL_V

Product:	MRP - Master Scheduling/MRP
Description:	An Integration Toolkit view supporting the information for the resource availability of each of the resources
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT R.RESOURCE_CODE
, R.DEPARTMENT_CODE
, TRUNC(NRA.SHIFT_DATE) + NRA.FROM_TIME/86400
, TRUNC(NRA.SHIFT_DATE) + NRA.TO_TIME/86400 + DECODE(SIGN(NRA.TO_TIME - NRA.FROM_TIME)
, -1
, 1
, 0)
, NRA.SHIFT_NUM
, NRA.CAPACITY_UNITS
, NRA.ORGANIZATION_ID
, NRA.RESOURCE_ID
, NRA.DEPARTMENT_ID
, NRA.SIMULATION_SET
FROM MRP_RHX_BOM_DEPT_RESOURCES_V R
, MRP_NET_RESOURCE_AVAIL NRA
WHERE NRA.ORGANIZATION_ID = R.ORGANIZATION_ID
AND NRA.DEPARTMENT_ID = R.DEPARTMENT_ID
AND NRA.RESOURCE_ID = R.RESOURCE_ID

Columns

Name
RESOURCE_CODE
DEPARTMENT_CODE
START_TIME
END_TIME
SHIFT_NUM
CAPACITY_UNITS
ORGANIZATION_ID
RESOURCE_ID
DEPARTMENT_ID
SIMULATION_SET