DBA Data[Home] [Help]

APPS.PO_CONTERMS_UTL_GRP dependencies on PO_LINES_ALL

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:

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: