DBA Data[Home] [Help]

APPS.PO_CONTERMS_UTL_GRP dependencies on PO_LINES_DRAFT_ALL

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

Line 636: FROM po_lines_draft_all pol, mtl_system_items_b_kfv kfv

632: AND NVL(pol.cancel_flag,'N') ='N';
633: ELSE -- CLM Mod
634: SELECT DISTINCT kfv.concatenated_segments
635: BULK COLLECT INTO l_item_tbl
636: FROM po_lines_draft_all pol, mtl_system_items_b_kfv kfv
637: WHERE pol.item_id = kfv.inventory_item_id
638: AND pol.draft_id = p_document_id
639: AND NVL(pol.delete_flag,'N') ='N';
640: END IF; --l_is_mod = 'N' THEN -- CLM Mod