View: EAM_RESOURCES_V

Product:	EAM - Enterprise Asset Management
Description:	View shows all the resources for a work order based on table cst_eam_wo_estimate_details
Implementation/DBA Data:	APPS.EAM_RESOURCES_V

View Text

SELECT EED.WIP_ENTITY_ID
, EED.ORGANIZATION_ID
, EED.OPERATIONS_DEPT_ID
, EED.OPERATIONS_SEQ_NUM
, BD.DEPARTMENT_CODE
, BR.RESOURCE_CODE
, EED.RESOURCE_RATE
, EED.UOM
, EED.RESOURCE_USAGE
, EED.RESOURCE_RATE*EED.RESOURCE_USAGE
FROM CST_EAM_WO_ESTIMATE_DETAILS EED
, BOM_RESOURCE_EMPLOYEES BRE
, BOM_RESOURCES BR
, BOM_DEPARTMENTS BD
WHERE EED.RESOURCE_ID=BR.RESOURCE_ID
AND EED.RESOURCE_ID=BRE.RESOURCE_ID(+)
AND EED.RESOURCE_INSTANCE_ID=BRE.INSTANCE_ID(+)
AND EED.ORGANIZATION_ID=BD.ORGANIZATION_ID
AND BD.DEPARTMENT_ID=EED.OWNING_DEPT_ID
AND BR.RESOURCE_TYPE=2 UNION SELECT EED.WIP_ENTITY_ID
, EED.ORGANIZATION_ID
, EED.OPERATIONS_DEPT_ID
, EED.OPERATIONS_SEQ_NUM
, BD.DEPARTMENT_CODE
, BR.RESOURCE_CODE
, EED.RESOURCE_RATE
, EED.UOM
, EED.RESOURCE_USAGE
, EED.RESOURCE_RATE*EED.RESOURCE_USAGE
FROM CST_EAM_WO_ESTIMATE_DETAILS EED
, BOM_RESOURCE_EQUIPMENTS BRE
, BOM_RESOURCES BR
, BOM_DEPARTMENTS BD
WHERE EED.RESOURCE_ID=BR.RESOURCE_ID
AND EED.RESOURCE_ID=BRE.RESOURCE_ID(+)
AND EED.RESOURCE_INSTANCE_ID=BRE.INSTANCE_ID(+)
AND EED.ORGANIZATION_ID=BD.ORGANIZATION_ID
AND BD.DEPARTMENT_ID=EED.OWNING_DEPT_ID
AND BR.RESOURCE_TYPE=1

Columns