DBA Data[Home] [Help]

APPS.CSF_PREVENTIVE_MAINTENANCE_PVT dependencies on CS_INCIDENT_LINKS

Line 94: from cs_incident_links cil

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

Line 966: cs_incident_links cil,

962: cccv.counter_id,
963: cccv.counter_name,
964: nvl(cccv.net_reading,0) net_reading
965: From ahl_unit_effectivities_app_v aueb,
966: cs_incident_links cil,
967: cs_incidents_all_b csi,
968: csi_cp_counters_v cccv
969: Where (aueb.status_code is NULL
970: or aueb.status_code = 'INIT-DUE')

Line 1136: cs_incident_links cil,

1132: jtb.actual_start_date,
1133: jtb.actual_end_date,
1134: jtb.object_version_number tasks_object_version
1135: From ahl_unit_effectivities_app_v aueb,
1136: cs_incident_links cil,
1137: cs_incidents_all_b csi,
1138: jtf_tasks_b jtb
1139: Where aueb.status_code in ('TERMINATED','EXCEPTION')
1140: -- Application_usg_code PM for Preventive Maintenance seeded for CMRO 11.5.10 changes