APPS.INV_MWB_QUERY_MANAGER dependencies on PO_HEADERS_ALL

Line 1698: FROM po_headers_all pha

1694: ELSE -- PO
1695: l_mtl_location := document_type_meaning(1);
1696: UPDATE mtl_mwb_gtmp
1697: SET document_number = (SELECT segment1
1698: FROM po_headers_all pha
1699: WHERE pha.po_header_id = rec.po_header_id)
1700: , document_type = l_mtl_location
1701: , document_type_id = 1
1702: WHERE po_header_id = rec.po_header_id;

Line 1762: FROM po_headers_all

1758: SELECT vendor_id
1759: , vendor_site_id
1760: INTO l_vendor_id
1761: , l_vendor_site_id
1762: FROM po_headers_all
1763: WHERE po_header_id = rec.po_header_id;
1764:
1765: UPDATE mtl_mwb_gtmp
1766: SET vendor_id = l_vendor_id

Line 3332: inv_mwb_query_manager.add_from_clause('po_headers_all pha','INBOUND');

3328: OR inv_mwb_globals.g_vendor_item IS NOT NULL THEN
3329:
3330: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'Supplier tab');
3331:
3332: inv_mwb_query_manager.add_from_clause('po_headers_all pha','INBOUND');
3333: inv_mwb_query_manager.add_where_clause(' pha.po_header_id = ms.po_header_id ','INBOUND');
3334: inv_mwb_query_manager.add_where_clause('pha.authorization_status = ''APPROVED''', 'INBOUND');
3335:
3336: /* IF inv_mwb_globals.g_include_po_without_asn = 1 THEN