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:
570: l_category_tbl category_table_type;
571: l_item_tbl item_table_type;
572:
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
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