APPS.OKS_OCINT_PUB dependencies on OKC_K_ITEMS

Line 2556: FROM okc_k_items

2552: SET toplvl_price_qty = (SELECT Sum(quantity)
2553: FROM OKS_SUBSCR_ELEMENTS_V
2554: WHERE DNZ_CLE_ID=l_lineid),
2555: toplvl_uom_code = (SELECT uom_code
2556: FROM okc_k_items
2557: WHERE cle_id=l_lineid)
2558: WHERE cle_id=l_lineid;
2559:
2560: l_sub_qty :=l_ordered_qty;

Line 4859: okc_k_items KI,

4855: Select KL.dnz_chr_id, KL.start_date, NVL(KL.date_terminated - 1,KL.end_date) end_date,
4856: KI.number_of_items, KI.uom_code,
4857: NVL(MTL.contract_item_type_code,'NON-SUB'), MTL.coverage_schedule_id, MTL.comms_nl_trackable_flag
4858: From okc_k_lines_b KL,
4859: okc_k_items KI,
4860: mtl_system_items MTL
4861: Where KL.id = p_cle_id
4862: and KI.cle_id = p_cle_id
4863: and MTL.inventory_item_id = TO_NUMBER(KI.object1_id1)