324: )
325: )
326:
327: )fact
328: ,csi_item_instances cii /* table that contains the instance_id, category and criticality */
329: ,EAM_ORG_MAINT_DEFAULTS eomd /* table containing the owning department */
330:
331: where
332: fact.maintenance_object_id = cii.instance_id
627: )
628: )
629: )
630: ) a
631: , csi_item_instances cii /* extract the instance_id,category and criticality of the asset */
632: , eam_org_maint_defaults eomd /* extract the department of the asset */
633: where
634: a.maintenance_object_id = cii.instance_id
635: and a.maintenance_object_id = eomd.object_id(+) /* department is not mandatory */