APPS.PO_CONTERMS_UTL_GRP dependencies on PO_LINES_ALL

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 629: FROM po_lines_all pol, mtl_system_items_b_kfv kfv

625: -- join: po_header_id, item_id
626: IF l_is_mod = 'N' THEN -- CLM Mod
627: SELECT DISTINCT kfv.concatenated_segments
628: BULK COLLECT INTO l_item_tbl
629: FROM po_lines_all pol, mtl_system_items_b_kfv kfv
630: WHERE pol.item_id = kfv.inventory_item_id
631: AND pol.po_header_id = p_document_id
632: AND NVL(pol.cancel_flag,'N') ='N';
633: ELSE -- CLM Mod