APPS.OKS_UTIL_PUB dependencies on OKC_K_ITEMS

Line 708: -- p_object1_id1 : Object Id 1 (object1_id1 from okc_k_items)

704: -- ===========================================================================
705: -- Function get_line_name
706: -- Input Parameters:
707: -- p_lty_code : Line Type Code (lty_code from okc_line_styles_b)
708: -- p_object1_id1 : Object Id 1 (object1_id1 from okc_k_items)
709: -- p_object1_id2 : Object Id 2 (object1_id2 from okc_k_items)
710: -- Return Value:
711: -- Name of the line item (VARCHAR2)
712: -- This function returns the name of a covered level

Line 709: -- p_object1_id2 : Object Id 2 (object1_id2 from okc_k_items)

705: -- Function get_line_name
706: -- Input Parameters:
707: -- p_lty_code : Line Type Code (lty_code from okc_line_styles_b)
708: -- p_object1_id1 : Object Id 1 (object1_id1 from okc_k_items)
709: -- p_object1_id2 : Object Id 2 (object1_id2 from okc_k_items)
710: -- Return Value:
711: -- Name of the line item (VARCHAR2)
712: -- This function returns the name of a covered level
713: -- with one of the line types:

Line 787: okc_k_items item

783: -- Service Counters
784: CURSOR svcctrcur(p_line_id IN NUMBER) IS
785: SELECT concatenated_segments name
786: FROM mtl_system_items_b_kfv mtl,
787: okc_k_items item
788: WHERE mtl.inventory_item_id = to_number(item.object1_id1)
789: AND mtl.organization_id = to_number(item.object1_id2)
790: AND item.cle_id = p_line_id;
791:

Line 840: FROM okc_k_lines_b sle, okc_k_items item, okc_line_styles_b lse

836: -- To be used if only the line id is known
837: FUNCTION get_line_name( p_subline_id IN NUMBER ) RETURN VARCHAR2 IS
838: CURSOR sublinecur IS
839: SELECT lse.lty_code, item.object1_id1, item.object1_id2
840: FROM okc_k_lines_b sle, okc_k_items item, okc_line_styles_b lse
841: WHERE item.cle_id = sle.id
842: AND lse.id = sle.lse_id
843: AND sle.id = p_subline_id;
844: l_name VARCHAR2(200);