APPS.CSI_ML_INTERFACE_TXN_PVT dependencies on CSI_ITEM_INSTANCES

Line 19: FROM csi_item_instances csi,

15: WHERE inst_interface_id = p_interface_id;
16:
17: CURSOR serial_cur(p_interface_id IN NUMBER) IS
18: SELECT cii.instance_id
19: FROM csi_item_instances csi,
20: csi_instance_interface cii
21: WHERE cii.inst_interface_id = p_interface_id
22: AND csi.inventory_item_id = cii.inventory_item_id
23: AND csi.serial_number = cii.serial_number;

Line 27: FROM csi_item_instances a,

23: AND csi.serial_number = cii.serial_number;
24:
25: CURSOR nonserial_cur(p_interface_id IN NUMBER) IS
26: SELECT a.instance_id
27: FROM csi_item_instances a,
28: csi_i_parties b,
29: csi_instance_interface c,
30: csi_i_party_interface d
31: WHERE a.instance_id = b.instance_id

Line 432: FROM csi_item_instances b

428:
429:
430: UPDATE CSI_INSTANCE_INTERFACE a
431: SET a.instance_id = (SELECT b.instance_id
432: FROM csi_item_instances b
433: WHERE a.instance_number = b.instance_number)
434: WHERE a.instance_number IS NOT NULL
435: and a.instance_id is null
436: AND a.SOURCE_SYSTEM_NAME = nvl(p_source_system_name, a.SOURCE_SYSTEM_NAME); --Added this condition for #6443959