APPS.CSD_RECALLS_PVT dependencies on CS_INCIDENTS_ALL_B

Line 397: cs_incidents_all_b cs,

393: msi.concatenated_segments
394: FROM csd_recall_lines crl,
395: csi_item_instances cii,
396: csd_repairs cr,
397: cs_incidents_all_b cs,
398: mtl_system_items_kfv msi
399: WHERE crl.processing_group_id = p_group_id
400: AND crl.instance_id = cii.instance_id
401: AND crl.repair_line_id = cr.repair_line_id (+)

Line 1363: cs_incidents_all_b sr,

1359: FROM csd_recall_metrics crm,
1360: csd_recall_headers_b crh,
1361: csd_recall_lines crl,
1362: csi_item_instances cii,
1363: cs_incidents_all_b sr,
1364: cs_incident_statuses_b cis
1365: WHERE crm.metric_id IN
1366: (SELECT * FROM TABLE(CAST(l_metric_ids AS JTF_NUMBER_TABLE)))
1367: AND crm.recall_number = crh.recall_number

Line 1420: cs_incidents_all_b sr,

1416: BULK COLLECT INTO l_recall_numbers,l_gen_num_tbl
1417: FROM csd_recall_metrics crm,
1418: csd_recall_headers_b crh,
1419: csd_recall_lines crl,
1420: cs_incidents_all_b sr,
1421: cs_incident_statuses_b cis,
1422: csi_item_instances cii
1423: WHERE crm.metric_id IN
1424: (SELECT * FROM TABLE(CAST(l_metric_ids AS JTF_NUMBER_TABLE)))

Line 1464: cs_incidents_all_b sr,

1460: COUNT(crl.owner_party_id) party_id
1461: FROM csd_recall_metrics crm,
1462: csd_recall_headers_b crh,
1463: csd_recall_lines crl,
1464: cs_incidents_all_b sr,
1465: cs_incident_statuses_b cis
1466: WHERE crm.metric_id IN
1467: (SELECT * FROM TABLE(CAST(l_metric_ids AS JTF_NUMBER_TABLE)))
1468: AND crm.recall_number = crh.recall_number

Line 1477: cs_incidents_all_b sr1,

1473: AND NOT EXISTS
1474: (SELECT 'exists'
1475: FROM csd_recall_headers_b crh1,
1476: csd_recall_lines crl1,
1477: cs_incidents_all_b sr1,
1478: cs_incident_statuses_b cis1,
1479: csd_recall_metrics crm1
1480: WHERE crm1.metric_id IN
1481: (SELECT * FROM TABLE(CAST(l_metric_ids AS JTF_NUMBER_TABLE)))