APPS.CSD_RECALLS_PVT dependencies on CS_INCIDENT_STATUSES_B

Line 1364: cs_incident_statuses_b cis

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
1368: AND crh.recall_id = crl.recall_id

Line 1421: cs_incident_statuses_b cis,

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)))
1425: AND crm.recall_number = crh.recall_number

Line 1465: cs_incident_statuses_b cis

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
1469: AND crh.recall_id = crl.recall_id

Line 1478: cs_incident_statuses_b cis1,

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)))
1482: AND crm1.recall_number = crh1.recall_number