View: EAM_INSTANCES

Product:	EAM - Enterprise Asset Management
Description:	View for getting the resource instances- both person and equipment
Implementation/DBA Data:	APPS.EAM_INSTANCES

View Text

SELECT PAPF.FULL_NAME
, BRE.ORGANIZATION_ID
FROM PER_ALL_PEOPLE_F PAPF
, BOM_RESOURCE_EMPLOYEES BRE
, BOM_RESOURCES BR1
WHERE BRE.EFFECTIVE_START_DATE=PAPF.EFFECTIVE_START_DATE
AND BRE.EFFECTIVE_END_DATE=PAPF.EFFECTIVE_END_DATE
AND PAPF.PERSON_ID=BRE.PERSON_ID
AND BRE.RESOURCE_ID=BR1.RESOURCE_ID
AND BRE.ORGANIZATION_ID=BR1.ORGANIZATION_ID
AND BR1.RESOURCE_TYPE=2 UNION SELECT MSIK.CONCATENATED_SEGMENTS
, MSIK.ORGANIZATION_ID
FROM MTL_SYSTEM_ITEMS_KFV MSIK
, BOM_RESOURCE_EQUIPMENTS BRE
, BOM_RESOURCES BR2
WHERE BRE.INVENTORY_ITEM_ID=MSIK.INVENTORY_ITEM_ID
AND MSIK.ITEM_TYPE='EQ'
AND BRE.RESOURCE_ID=BR2.RESOURCE_ID
AND BRE.ORGANIZATION_ID=BR2.ORGANIZATION_ID
AND BR2.RESOURCE_TYPE=1

Columns