DBA Data[Home] [Help]

APPS.PO_CONTERMS_UTL_GRP dependencies on MTL_CATEGORIES_B_KFV

Line 487: mtl_categories_b_kfv.concatenated_segments%TYPE;

483: l_api_version CONSTANT NUMBER := 1.0;
484:
485:
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:

Line 518: FROM po_lines_all pol, mtl_categories_b_kfv kfv

514: -- why : Contracts needs to validate terms based on categories
515: -- join: po_header_id, category_id
516: SELECT DISTINCT kfv.concatenated_segments
517: BULK COLLECT INTO l_category_tbl
518: FROM po_lines_all pol, mtl_categories_b_kfv kfv
519: WHERE pol.category_id = kfv.category_id
520: AND pol.po_header_id = p_document_id
521: AND NVL(pol.cancel_flag,'N') ='N';
522: