APPS.OKS_ARFEEDER_PUB dependencies on OKC_K_ITEMS

Line 990: FROM OKC_K_ITEMS

986: SELECT Object1_id1,
987: Number_of_items,
988: UOM_code,
989: object1_id2
990: FROM OKC_K_ITEMS
991: WHERE CLE_ID = p_id;
992:
993: Cursor Prim_uom_cur(p_id In NUMBER, p_org_id IN NUMBER) IS
994: SELECT primary_uom_code

Line 2571: where instance_id in (select to_number(itm.object1_id1) from okc_k_items itm

2567:
2568:
2569: Cursor Cur_Parent_Order_line(p_id IN NUMBER) IS
2570: SELECT last_oe_order_line_id from csi_item_instances
2571: where instance_id in (select to_number(itm.object1_id1) from okc_k_items itm
2572: where itm.cle_id = p_id
2573: and jtot_object1_code = 'OKX_CUSTPROD');
2574:
2575:

Line 2592: FROM OKC_K_ITEMS

2588:
2589: Cursor cur_okc_k_item_qty(p_id IN NUMBER) IS
2590: SELECT Number_of_items,
2591: UOM_code
2592: FROM OKC_K_ITEMS
2593: WHERE CLE_ID = p_id;
2594:
2595:
2596: Cursor Interface_pb_cur IS