APPS.CSI_ML_UTIL_PVT dependencies on CSI_ITEM_INSTANCES

Line 1794: FROM csi_item_instances cii

1790: WHERE cir.subject_id = l_subject_id
1791: AND cir.relationship_type_code = p_rel_type_code
1792: AND nvl(cir.relationship_end_date,(sysdate+1)) > sysdate
1793: AND EXISTS (SELECT 'x'
1794: FROM csi_item_instances cii
1795: WHERE cii.instance_id = cir.object_id
1796: AND cii.location_type_code NOT IN ('INVENTORY','PO','IN_TRANSIT','WIP','PROJECT')
1797: );
1798: l_subject_id := l_object_id;

Line 1996: FROM csi_item_instances

1992: THEN
1993: BEGIN
1994: SELECT quantity
1995: INTO l_quantity
1996: FROM csi_item_instances
1997: WHERE instance_id=r_id.object_id
1998: AND (SYSDATE BETWEEN NVL(active_start_date, SYSDATE) AND NVL(active_end_date, SYSDATE));
1999:
2000: IF l_quantity <> 1

Line 2083: FROM csi_item_instances

2079: THEN
2080: BEGIN
2081: SELECT 'x'
2082: INTO l_exists
2083: FROM csi_item_instances
2084: WHERE instance_id=r_id.subject_id
2085: AND (SYSDATE BETWEEN NVL(active_start_date, SYSDATE) AND NVL(active_end_date, SYSDATE));
2086: EXCEPTION
2087: WHEN NO_DATA_FOUND THEN

Line 2429: FROM csi_item_instances

2425: ,l_instance_rec.pa_project_task_id
2426: ,l_instance_rec.in_transit_order_line_id
2427: ,l_instance_rec.wip_job_id
2428: ,l_instance_rec.po_order_line_id
2429: FROM csi_item_instances
2430: WHERE instance_id=l_upd_obj_id;
2431:
2432: SELECT instance_id
2433: ,object_version_number

Line 2436: FROM csi_item_instances

2432: SELECT instance_id
2433: ,object_version_number
2434: INTO l_instance_rec.instance_id
2435: ,l_instance_rec.object_version_number
2436: FROM csi_item_instances
2437: WHERE instance_id = l_upd_ins_csr.subject_id;
2438:
2439:
2440: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2599: FROM csi_item_instances

2595: ,l_instance_rec.pa_project_task_id
2596: ,l_instance_rec.in_transit_order_line_id
2597: ,l_instance_rec.wip_job_id
2598: ,l_instance_rec.po_order_line_id
2599: FROM csi_item_instances
2600: WHERE instance_id=l_upd_obj_id;
2601:
2602: SELECT instance_id
2603: ,object_version_number

Line 2606: FROM csi_item_instances

2602: SELECT instance_id
2603: ,object_version_number
2604: INTO l_instance_rec.instance_id
2605: ,l_instance_rec.object_version_number
2606: FROM csi_item_instances
2607: WHERE instance_id = l_re_upd_csr.subject_id;
2608:
2609: l_return_status := FND_API.G_RET_STS_SUCCESS;
2610: