APPS.OKS_IB_UTIL_PVT dependencies on CSI_ITEM_INSTANCES

Line 269: ,csi_item_instances csi, csi_systems_tl sys

265:
266:
267: Select mtl.concatenated_segments, sys.name
268: From mtl_system_items_kfv mtl, okc_k_items_v itm
269: ,csi_item_instances csi, csi_systems_tl sys
270: where itm.cle_id = P_line_id
271: And itm.jtot_object1_code = 'OKX_CUSTPROD'
272: And csi.instance_id = itm.object1_id1
273: And csi.inventory_item_id = mtl.inventory_item_id

Line 284: ,csi_item_instances csi

280: Cursor l_counter_csr Is
281: Select mtl.concatenated_segments
282: From mtl_system_items_kfv mtl, csi_counter_associations ctrAsc
283: , okc_k_items_v itm
284: ,csi_item_instances csi
285: Where itm.cle_id = P_line_id
286: And ctrAsc.counter_id = itm.object1_id1
287: And csi.instance_id = ctrAsc.source_object_id
288: And mtl.inventory_item_id = csi.inventory_item_id

Line 1161: From Csi_item_instances

1157: Where id1 = p_cust_id;
1158:
1159: Cursor l_instance_csr Is
1160: Select owner_party_id
1161: From Csi_item_instances
1162: Where instance_id = p_instance_id;
1163:
1164: l_new_party_id Number;
1165: l_old_party_id Number;

Line 1262: From Csi_item_instances

1258: Where id1 = p_cust_id;
1259:
1260: Cursor l_instance_csr Is
1261: Select owner_party_id
1262: From Csi_item_instances
1263: Where instance_id = p_instance_id;
1264:
1265: l_new_party_id Number;
1266: l_old_party_id Number;

Line 1336: From Csi_item_instances

1332: Where id1 = p_cust_id;
1333:
1334: Cursor l_instance_csr Is
1335: Select owner_party_id
1336: From Csi_item_instances
1337: Where instance_id = p_instance_id;
1338:
1339: l_new_party_id Number;
1340: l_old_party_id Number;

Line 2248: csi_item_instances csi

2244: FROM okc_k_lines_b sl,
2245: oks_k_lines_b tls,
2246: oks_k_lines_b tls1,
2247: okc_k_items im,
2248: csi_item_instances csi
2249:
2250: WHERE sl.id = p_line_id
2251: AND sl.id = im.cle_id
2252: AND im.jtot_object1_code = 'OKX_CUSTPROD'

Line 2589: ,csi_item_instances csi

2585: CURSOR get_prod_name_csr IS
2586: SELECT mtl.concatenated_segments
2587: From mtl_system_items_kfv mtl,
2588: okc_k_items_v itm
2589: ,csi_item_instances csi
2590: where itm.object1_id1 = p_object1_id1
2591: And itm.jtot_object1_code = 'OKX_CUSTPROD'
2592: And csi.instance_id = itm.object1_id1
2593: And csi.inventory_item_id = mtl.inventory_item_id