DBA Data[Home] [Help]

APPS.OKS_IB_UTIL_PVT dependencies on OKC_K_ITEMS_V

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 283: , okc_k_items_v itm

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
287: And csi.instance_id = ctrAsc.source_object_id

Line 1590: From OKC_K_ITEMS_V KI

1586: , 0
1587: , 0
1588: , 0
1589: , null
1590: From OKC_K_ITEMS_V KI
1591: , OKC_K_HEADERS_ALL_B KH
1592: , OKC_K_LINES_B KL
1593: , OKC_STATUSES_B ST
1594: , OKS_K_LINES_B KS

Line 2588: okc_k_items_v itm

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'
2592: And csi.instance_id = itm.object1_id1