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]

MATERIALIZED VIEW: APPS.ENI_RES_1_MV

Source


select /* 12.0: bug#4526784 */
	1 as marker
	, resdept.rowid resdept_rowid
	, res.rowid res_rowid
	, dept.rowid dept_rowid
	, res.resource_id
	, res.resource_code
	, res.resource_type as bom_resource_type
	, res.organization_id
	, res.unit_of_measure
	, dept.department_id
	, dept.department_code
	, resdept.resource_group_name resource_group
	, res.disable_date
from
	BOM.BOM_DEPARTMENT_RESOURCES resdept
	, BOM.BOM_RESOURCES res
	, BOM.BOM_DEPARTMENTS dept
where
	resdept.resource_id = res.resource_id
	and  resdept.department_id = dept.department_id
UNION ALL
select
	2 as marker
	, rowid resdept_rowid
	, null
	, null
	, resource_id
	, resource_code
	, resource_type
	, organization_id
	, unit_of_measure
	, null
	, null
	, null
	, disable_date
from
	BOM.BOM_RESOURCES