DBA Data[Home] [Help]

APPS.OKS_REPRICE_PVT dependencies on OKC_K_ITEMS

Line 408: okc_k_items itm,

404:
405: CURSOR l_oks_elements (p_line_id NUMBER) IS
406: SELECT itm.number_of_items,kln.toplvl_uom_code,lin.date_terminated
407: FROM oks_k_lines_b kln,
408: okc_k_items itm,
409: okc_k_lines_b lin
410: WHERE kln.cle_id = p_line_id
411: and itm.cle_id = kln.cle_id
412: and lin.id = p_line_id;

Line 416: from okc_k_items itm,

412: and lin.id = p_line_id;
413:
414: Cursor check_sub_instance IS
415: select 'Y'
416: from okc_k_items itm,
417: oks_subscr_header_b sub
418: where itm.cle_id = p_id
419: and sub.instance_id = itm.object1_id1;
420: