DBA Data[Home] [Help]

APPS.OKS_IB_UTIL_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 268: From mtl_system_items_kfv mtl, okc_k_items_v itm

264: Is
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

Line 282: From mtl_system_items_kfv mtl, csi_counter_associations ctrAsc

278:
279:
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

Line 2587: From mtl_system_items_kfv mtl,

2583: l_chr_id NUMBER;
2584:
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'