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_DEPT_RESOURCES_V

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

View Text

SELECT BR.RESOURCE_CODE
, BD.DEPARTMENT_CODE
, BR.DESCRIPTION
, BR.DISABLE_DATE
, BD.DISABLE_DATE
, BDR.CAPACITY_UNITS
, BDR.AVAILABLE_24_HOURS_FLAG
, BR.UNIT_OF_MEASURE
, BDR.ATTRIBUTE_CATEGORY
, BDR.ATTRIBUTE1
, BDR.ATTRIBUTE2
, BDR.ATTRIBUTE3
, BDR.ATTRIBUTE4
, BDR.ATTRIBUTE5
, BDR.ATTRIBUTE6
, BDR.ATTRIBUTE7
, BDR.ATTRIBUTE8
, BDR.ATTRIBUTE9
, BDR.ATTRIBUTE10
, BDR.ATTRIBUTE11
, BDR.ATTRIBUTE12
, BDR.ATTRIBUTE13
, BDR.ATTRIBUTE14
, BDR.ATTRIBUTE15
, BR.RESOURCE_ID
, BD.DEPARTMENT_ID
, BDR.SHARE_CAPACITY_FLAG
, BDR.SHARE_FROM_DEPT_ID
, BR.ORGANIZATION_ID
FROM BOM_DEPARTMENTS BD
, BOM_DEPARTMENT_RESOURCES BDR
, BOM_RESOURCES BR
WHERE TRUNC(NVL(BR.DISABLE_DATE
, TRUNC(SYSDATE)+1)) > (TRUNC(SYSDATE) - MRP_RHX_EXT_APS.GET_CONSTANT)
AND BDR.RESOURCE_ID = BR.RESOURCE_ID
AND TRUNC(NVL(BD.DISABLE_DATE
, TRUNC(SYSDATE)+1)) > (TRUNC(SYSDATE) - MRP_RHX_EXT_APS.GET_CONSTANT)
AND BD.ORGANIZATION_ID = BR.ORGANIZATION_ID
AND BDR.DEPARTMENT_ID = BD.DEPARTMENT_ID

Columns

Name
RESOURCE_CODE
DEPARTMENT_CODE
DESCRIPTION
RESOURCE_DISABLE_DATE
DEPARTMENT_DISABLE_DATE
CAPACITY_UNITS
AVAILABLE_24_HOURS_FLAG
UNIT_OF_MEASURE
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
RESOURCE_ID
DEPARTMENT_ID
SHARE_CAPACITY_FLAG
SHARE_FROM_DEPT_ID
ORGANIZATION_ID