APPS.CSI_INV_TRXS_PKG dependencies on CSI_ITEM_INSTANCES

Line 109: FROM csi_item_instances

105: r_id c_id%rowtype;
106:
107: CURSOR c_obj_version (pc_instance_id IN NUMBER) is
108: SELECT object_version_number
109: FROM csi_item_instances
110: WHERE instance_id = pc_instance_id;
111:
112: CURSOR c_phys_inv_info (pc_physical_adjustment_id IN NUMBER) is
113: SELECT mpi.physical_inventory_id physical_inventory_id,

Line 619: FROM csi_item_instances

615:
616: BEGIN
617: SELECT owner_party_id
618: INTO l_owner_party_id
619: FROM csi_item_instances
620: WHERE instance_id = l_src_instance_header_tbl(i).instance_id;
621:
622: EXCEPTION
623: WHEN no_data_found THEN

Line 712: FROM csi_item_instances

708:
709: BEGIN
710: SELECT owner_party_id
711: INTO l_owner_party_id
712: FROM csi_item_instances
713: WHERE instance_id = l_src_instance_header_tbl(i).instance_id;
714:
715: EXCEPTION
716: WHEN no_data_found THEN

Line 1238: FROM csi_item_instances

1234: r_id c_id%rowtype;
1235:
1236: CURSOR c_obj_version (pc_instance_id IN NUMBER) is
1237: SELECT object_version_number
1238: FROM csi_item_instances
1239: WHERE instance_id = pc_instance_id;
1240:
1241: BEGIN
1242: x_return_status := l_fnd_success;

Line 1752: FROM csi_item_instances

1748:
1749: BEGIN
1750: SELECT owner_party_id
1751: INTO l_owner_party_id
1752: FROM csi_item_instances
1753: WHERE instance_id = l_src_instance_header_tbl(i).instance_id;
1754:
1755: EXCEPTION
1756: WHEN no_data_found THEN

Line 4053: ,csi_item_instances_h ciih

4049: CURSOR get_redeploy_flag_cur
4050: IS
4051: SELECT 'Y' redeploy_flag
4052: FROM csi_transactions ct
4053: ,csi_item_instances_h ciih
4054: ,csi_item_instances cii
4055: WHERE ct.transaction_id = ciih.transaction_id
4056: AND ciih.instance_id = cii.instance_id
4057: AND cii.inventory_item_id = p_inventory_item_id

Line 4054: ,csi_item_instances cii

4050: IS
4051: SELECT 'Y' redeploy_flag
4052: FROM csi_transactions ct
4053: ,csi_item_instances_h ciih
4054: ,csi_item_instances cii
4055: WHERE ct.transaction_id = ciih.transaction_id
4056: AND ciih.instance_id = cii.instance_id
4057: AND cii.inventory_item_id = p_inventory_item_id
4058: AND cii.serial_number = p_serial_number