DBA Data[Home] [Help]

APPS.CS_CHG_AUTO_SUB_CON_PKG dependencies on JTF_TASKS_VL

Line 346: FROM jtf_tasks_vl jtv,

342: AND ced.source_code = 'SD'
343: AND ced.original_source_code = 'SR'
344: AND ced.interface_to_oe_flag = 'Y'
345: AND ciab.incident_id NOT IN (SELECT jtv.source_object_id
346: FROM jtf_tasks_vl jtv,
347: jtf_task_statuses_b jts
348: -- jtf_task_assignments jta,
349: -- csf_debrief_headers cdh
350: WHERE jtv.source_object_id = ciab.incident_id

Line 387: FROM jtf_tasks_vl jtv,

383: AND ced.source_code = 'SD'
384: AND ced.original_source_code = 'SR'
385: AND ced.interface_to_oe_flag = 'Y'
386: AND ciab.incident_id IN (SELECT jtv.source_object_id
387: FROM jtf_tasks_vl jtv,
388: jtf_task_statuses_b jts,
389: jtf_task_assignments jta,
390: csf_debrief_headers cdh
391: WHERE jtv.source_object_id = ciab.incident_id