View: MTL_EAM_EQUIP_RESOURCES_V

Product:	INV - Inventory
Description:	View for EAM equipment resources
Implementation/DBA Data:	APPS.MTL_EAM_EQUIP_RESOURCES_V

View Text

SELECT BDR.ROWID ROW_ID
, BRE.ORGANIZATION_ID
, BRE.INVENTORY_ITEM_ID
, BDRI.SERIAL_NUMBER
, BRE.RESOURCE_ID
, BR.RESOURCE_CODE
, BR.DESCRIPTION
, BRE.INSTANCE_ID
, BDR.DEPARTMENT_ID
, BD.DEPARTMENT_CODE
, BDR.SHARE_FROM_DEPT_ID
, BD1.DEPARTMENT_CODE SHARE_FROM_DEPT_CODE
, DECODE(BD1.DEPARTMENT_CODE
, NULL
, BD.DEPARTMENT_CODE
, BD1.DEPARTMENT_CODE) OWNING_DEPARTMENT_CODE
, BDR.CAPACITY_UNITS
, BDR.AVAILABLE_24_HOURS_FLAG
, BDR.RESOURCE_GROUP_NAME
, BDR.SHARE_CAPACITY_FLAG
, BR.UNIT_OF_MEASURE
, BR.AUTOCHARGE_TYPE
, BDR.CTP_FLAG
, BDR.SCHEDULE_TO_INSTANCE
FROM BOM_DEPT_RES_INSTANCES BDRI
, BOM_RESOURCE_EQUIPMENTS BRE
, BOM_RESOURCES BR
, BOM_DEPARTMENT_RESOURCES BDR
, BOM_DEPARTMENTS BD
, BOM_DEPARTMENTS BD1
WHERE BDRI.RESOURCE_ID = BRE.RESOURCE_ID
AND BDRI.INSTANCE_ID = BRE.INSTANCE_ID
AND BR.ORGANIZATION_ID = BRE.ORGANIZATION_ID
AND BR.RESOURCE_ID = BRE.RESOURCE_ID
AND DECODE(BDR.SHARE_FROM_DEPT_ID
, NULL
, BDR.DEPARTMENT_ID
, BDR.SHARE_FROM_DEPT_ID) = BDRI.DEPARTMENT_ID
AND BDR.RESOURCE_ID = BRE.RESOURCE_ID
AND BD.DEPARTMENT_ID = BDR.DEPARTMENT_ID
AND BD1.DEPARTMENT_ID(+) = BDR.SHARE_FROM_DEPT_ID UNION SELECT ROW_ID
, ORGANIZATION_ID
, INVENTORY_ITEM_ID
, SERIAL_NUMBER
, RESOURCE_ID
, RESOURCE_CODE
, DESCRIPTION
, INSTANCE_ID
, DEPARTMENT_ID
, DEPARTMENT_CODE
, SHARE_FROM_DEPT_ID
, SHARE_FROM_DEPT_CODE
, OWNING_DEPARTMENT_CODE
, CAPACITY_UNITS
, AVAILABLE_24_HOURS_FLAG
, RESOURCE_GROUP_NAME
, SHARE_CAPACITY_FLAG
, UNIT_OF_MEASURE
, AUTOCHARGE_TYPE
, CTP_FLAG
, SCHEDULE_TO_INSTANCE
FROM GMP_EAM_EQUIP_RESOURCES_V

Columns