MATERIALIZED VIEW: APPS.ENI_RES_5_MV

Source

SELECT  /* 12.0: bug#4526784 */ 'BOM' resource_type,  rowid bom_rowid, to_char(resource_id)||'-'||to_char(department_id)||'-'||to_char(organization_id) id, resource_id resource_id, resource_code, bom_resource_type, organization_id, to_char(department_id) department_id, decode(department_id,-1,to_char(department_id),to_char(department_id)||'-1') department_fk, department_code, resource_group, decode(resource_group,'-1',resource_group,resource_group||'-1') resource_group_fk, unit_of_measure, disable_date FROM eni_res_3_mv WHERE department_id is not null UNION ALL SELECT 'OPM' resource_type, rowid bom_rowid, resource_id||'-'||department_id||'-'||to_char(organization_id) id, resource_id, resource_code, -1 as bom_resource_type, organization_id, department_id, decode(department_id,'-1',department_id,department_id||'-2') department_fk, department_code, resource_group, resource_group||'-2' resource_group_fk, unit_of_measure, disable_date FROM eni_res_4_mv