DBA Data[Home] [Help]

APPS.CSF_PREVENTIVE_MAINTENANCE_PVT dependencies on CS_INCIDENT_LINKS

Line 99: from cs_incident_links cil

95: and (aueb.status_code is NULL or aueb.status_code = 'INIT-DUE')
96: -- Application_usg_code PM for Preventive Maintenance seeded for CMRO 11.5.10 changes
97: and aueb.application_usg_code = 'PM'
98: and aueb.unit_effectivity_id not in (select object_id
99: from cs_incident_links cil
100: where cil.object_type = 'AHL_UMP_EFF'
101: and cil.link_type_id = 6)
102: -- link_type_id 6 is 'REFERS TO' seeded value
103: and csi.instance_id = aueb.csi_item_instance_id

Line 1006: cs_incident_links cil,

1002: cccv.counter_id,
1003: cccv.counter_name,
1004: nvl(cccv.net_reading,0) net_reading
1005: From ahl_unit_effectivities_app_v aueb,
1006: cs_incident_links cil,
1007: cs_incidents_all_b csi,
1008: csi_cp_counters_v cccv
1009: Where (aueb.status_code is NULL
1010: or aueb.status_code = 'INIT-DUE')

Line 1183: cs_incident_links cil,

1179: jtb.actual_start_date,
1180: jtb.actual_end_date,
1181: jtb.object_version_number tasks_object_version
1182: From ahl_unit_effectivities_app_v aueb,
1183: cs_incident_links cil,
1184: cs_incidents_all_b csi,
1185: jtf_tasks_b jtb
1186: Where aueb.status_code in ('TERMINATED','EXCEPTION')
1187: -- Application_usg_code PM for Preventive Maintenance seeded for CMRO 11.5.10 changes