DBA Data[Home] [Help]

APPS.PO_CONTERMS_UTL_GRP dependencies on MTL_SYSTEM_ITEMS_B_KFV

Line 490: mtl_system_items_b_kfv.concatenated_segments%TYPE;

486: TYPE category_table_type IS TABLE OF
487: mtl_categories_b_kfv.concatenated_segments%TYPE;
488:
489: TYPE item_table_type IS TABLE OF
490: mtl_system_items_b_kfv.concatenated_segments%TYPE;
491:
492: l_category_tbl category_table_type;
493: l_item_tbl item_table_type;
494:

Line 534: FROM po_lines_all pol, mtl_system_items_b_kfv kfv

530: -- why : Contracts needs to validate terms based on items
531: -- join: po_header_id, item_id
532: SELECT DISTINCT kfv.concatenated_segments
533: BULK COLLECT INTO l_item_tbl
534: FROM po_lines_all pol, mtl_system_items_b_kfv kfv
535: WHERE pol.item_id = kfv.inventory_item_id
536: AND pol.po_header_id = p_document_id
537: AND NVL(pol.cancel_flag,'N') ='N';
538: