APPS.OKS_ARFEEDER_PUB dependencies on OKC_K_ITEMS

Line 1004: FROM OKC_K_ITEMS

1000: SELECT Object1_id1,
1001: Number_of_items,
1002: UOM_code,
1003: object1_id2
1004: FROM OKC_K_ITEMS
1005: WHERE CLE_ID = p_id;
1006:
1007: Cursor Prim_uom_cur(p_id In NUMBER, p_org_id IN NUMBER) IS
1008: SELECT primary_uom_code

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

2586:
2587:
2588: Cursor Cur_Parent_Order_line(p_id IN NUMBER) IS
2589: SELECT last_oe_order_line_id from csi_item_instances
2590: where instance_id in (select to_number(itm.object1_id1) from okc_k_items itm
2591: where itm.cle_id = p_id
2592: and jtot_object1_code = 'OKX_CUSTPROD');
2593:
2594:

Line 2611: FROM OKC_K_ITEMS

2607:
2608: Cursor cur_okc_k_item_qty(p_id IN NUMBER) IS
2609: SELECT Number_of_items,
2610: UOM_code
2611: FROM OKC_K_ITEMS
2612: WHERE CLE_ID = p_id;
2613:
2614:
2615: Cursor Interface_pb_cur IS