APPS.ISC_MAINT_ASSET_DT_ETL_PKG dependencies on EAM_ORG_MAINT_DEFAULTS

Line 329: ,EAM_ORG_MAINT_DEFAULTS eomd /* table containing the owning department */

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
333: and fact.maintenance_object_id = eomd.object_id(+) /* an asset need not be owned to any dept */

Line 632: , eam_org_maint_defaults eomd /* extract the department of the asset */

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 */
636: and eomd.object_type(+)= 50 /* bug 4750689 */