[Home] [Help]
MATERIALIZED VIEW: APPS.ENI_RES_4_MV
Source
select /* 12.0: bug#4526784 */ mst.ROWID mst_rowid, dtl.ROWID dtl_rowid, dtl.resource_id resource_id, mst.resources resource_code, dtl.organization_id organization_id, dtl.usage_uom unit_of_measure, NVL(mst.resource_class, '-1') department_id, NVL(mst.resource_class, 'Unassigned') department_code, dtl.group_resource resource_group, DECODE(dtl.delete_mark, 1, dtl.last_update_date) disable_date FROM GMP.CR_RSRC_MST_B mst, GMP.CR_RSRC_DTL dtl WHERE mst.resources = dtl.resources