APPS.CSD_RECALLS_PVT dependencies on CSI_ITEM_INSTANCES

Line 102: csi_item_instances cii

98: wip_entities we,
99: wip_discrete_jobs wdj,
100: csd_service_codes_tl csc,
101: mtl_system_items_b msi,
102: csi_item_instances cii
103: WHERE crl.processing_group_id = p_rec_group_id
104: AND crl.repair_line_id = wdj.source_line_id
105: AND NVL(g_upgrade_item_id,crl.inventory_item_id) = wdj.primary_item_id
106: AND wdj.wip_entity_id = we.wip_entity_id

Line 395: csi_item_instances cii,

391: cs.incident_number,
392: cr.quantity,
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

Line 656: FROM csd_recall_lines crl,csi_item_instances cii

652: crl.repair_line_id,
653: crl.wip_entity_id,
654: cii.unit_of_measure,
655: cii.quantity
656: FROM csd_recall_lines crl,csi_item_instances cii
657: WHERE crl.processing_group_id = p_group_id
658: AND crl.processing_flag = 'Y'
659: AND crl.instance_id = cii.instance_id;
660:

Line 1271: csi_item_instances cii

1267: BULK COLLECT INTO l_recall_numbers,l_gen_num_tbl
1268: FROM csd_recall_metrics crm,
1269: csd_recall_headers_b crh,
1270: csd_recall_lines crl,
1271: csi_item_instances cii
1272: WHERE crm.metric_id IN (SELECT * FROM TABLE(CAST(l_metric_ids AS JTF_NUMBER_TABLE)))
1273: AND crm.recall_number = crh.recall_number
1274: AND crh.recall_id = crl.recall_id
1275: AND crl.instance_id = cii.instance_id

Line 1362: csi_item_instances cii,

1358: SUM(cii.quantity) quantity
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)))

Line 1422: csi_item_instances cii

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