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.ESTIMATED_COST
, M1.MEANING
, M2.MEANING
, EED.ESTIMATED_COST - (EED.RESOURCE_RATE*EED.RESOURCE_USAGE)
FROM CST_EAM_WO_ESTIMATE_DETAILS EED
, BOM_RESOURCES BR
, BOM_DEPARTMENTS BD
, MFG_LOOKUPS M1
, MFG_LOOKUPS M2
, WIP_OPERATION_RESOURCES WOR
WHERE EED.RESOURCE_ID=BR.RESOURCE_ID
AND EED.ORGANIZATION_ID=BD.ORGANIZATION_ID
AND BD.DEPARTMENT_ID=EED.OWNING_DEPT_ID
AND BR.RESOURCE_TYPE=2
AND M1.LOOKUP_TYPE='BOM_RESOURCE_TYPE'
AND M1.LOOKUP_CODE=2
AND M2.LOOKUP_TYPE='CST_BASIS'
AND WOR.BASIS_TYPE = M2.LOOKUP_CODE
AND WOR.RESOURCE_ID = BR.RESOURCE_ID
AND WOR.OPERATION_SEQ_NUM = EED.OPERATIONS_SEQ_NUM
AND WOR.WIP_ENTITY_ID = EED.WIP_ENTITY_ID
AND WOR.ORGANIZATION_ID = EED.ORGANIZATION_ID 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.ESTIMATED_COST
, M1.MEANING
, M2.MEANING
, EED.ESTIMATED_COST - (EED.RESOURCE_RATE*EED.RESOURCE_USAGE)
FROM CST_EAM_WO_ESTIMATE_DETAILS EED
, BOM_RESOURCES BR
, BOM_DEPARTMENTS BD
, MFG_LOOKUPS M1
, MFG_LOOKUPS M2
, WIP_OPERATION_RESOURCES WOR
WHERE EED.RESOURCE_ID=BR.RESOURCE_ID
AND EED.ORGANIZATION_ID=BD.ORGANIZATION_ID
AND BD.DEPARTMENT_ID=EED.OWNING_DEPT_ID
AND BR.RESOURCE_TYPE=1
AND M1.LOOKUP_TYPE='BOM_RESOURCE_TYPE'
AND M1.LOOKUP_CODE=1
AND M2.LOOKUP_TYPE='CST_BASIS'
AND WOR.BASIS_TYPE = M2.LOOKUP_CODE
AND WOR.RESOURCE_ID = BR.RESOURCE_ID
AND WOR.OPERATION_SEQ_NUM = EED.OPERATIONS_SEQ_NUM
AND WOR.WIP_ENTITY_ID = EED.WIP_ENTITY_ID
AND WOR.ORGANIZATION_ID = EED.ORGANIZATION_ID

Columns