APPS.PO_CONTERMS_UTL_GRP dependencies on MTL_CATEGORIES_B_KFV

Line 565: mtl_categories_b_kfv.concatenated_segments%TYPE;

561:
562: l_is_mod VARCHAR2(1) := 'N'; -- CLM Mod
563:
564: TYPE category_table_type IS TABLE OF
565: mtl_categories_b_kfv.concatenated_segments%TYPE;
566:
567: TYPE item_table_type IS TABLE OF
568: mtl_system_items_b_kfv.concatenated_segments%TYPE;
569:

Line 604: FROM po_lines_all pol, mtl_categories_b_kfv kfv

600: -- join: po_header_id, category_id
601: IF l_is_mod = 'N' THEN -- CLM Mod
602: SELECT DISTINCT kfv.concatenated_segments
603: BULK COLLECT INTO l_category_tbl
604: FROM po_lines_all pol, mtl_categories_b_kfv kfv
605: WHERE pol.category_id = kfv.category_id
606: AND pol.po_header_id = p_document_id
607: AND NVL(pol.cancel_flag,'N') ='N';
608: ELSE -- CLM Mod

Line 611: FROM po_lines_draft_all pol, mtl_categories_b_kfv kfv

607: AND NVL(pol.cancel_flag,'N') ='N';
608: ELSE -- CLM Mod
609: SELECT DISTINCT kfv.concatenated_segments
610: BULK COLLECT INTO l_category_tbl
611: FROM po_lines_draft_all pol, mtl_categories_b_kfv kfv
612: WHERE pol.category_id = kfv.category_id
613: AND pol.draft_id = p_document_id
614: AND NVL(pol.delete_flag,'N') ='N';
615: END IF; --l_is_mod = 'N' THEN -- CLM Mod