APPS.CSF_PREVENTIVE_MAINTENANCE_PVT dependencies on JTF_TASKS_B

Line 739: FROM jtf_tasks_b

735: SAVEPOINT Generate_SR_Tasks_PVT;
736:
737: SELECT task_id,object_version_number
738: BULK COLLECT INTO conf_task_id,conf_object_version_number
739: FROM jtf_tasks_b
740: WHERE source_object_id = x_request_id;
741:
742: FOR i in 1..conf_task_id.COUNT Loop
743: csf_tasks_pub.update_cust_confirmation(

Line 829: FROM jtf_tasks_b

825: IF (l_acchrs_found = true) THEN
826:
827: SELECT task_id,object_version_number
828: BULK COLLECT INTO conf_task_id,conf_object_version_number
829: FROM jtf_tasks_b
830: WHERE source_object_id = x_request_id;
831:
832:
833: FOR i in 1..conf_task_id.COUNT Loop

Line 1185: jtf_tasks_b jtb

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
1188: and aueb.application_usg_code = 'PM'
1189: and cil.object_id = aueb.unit_effectivity_id