DBA Data[Home] [Help]

APPS.INV_MWB_QUERY_MANAGER dependencies on PO_HEADERS_TRX_V

Line 1800: FROM po_headers_trx_v pha -- CLM project, bug 9403291

1796: ELSE -- PO
1797: l_mtl_location := document_type_meaning(1);
1798: UPDATE mtl_mwb_gtmp
1799: SET document_number = (SELECT segment1
1800: FROM po_headers_trx_v pha -- CLM project, bug 9403291
1801: WHERE pha.po_header_id = rec.po_header_id)
1802: , document_type = l_mtl_location
1803: , document_type_id = 1
1804: WHERE po_header_id = rec.po_header_id;

Line 4036: inv_mwb_query_manager.add_from_clause('po_headers_trx_v pha','INBOUND'); -- CLM project, bug 9403291

4032: OR inv_mwb_globals.g_vendor_item IS NOT NULL THEN
4033:
4034: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'Supplier tab');
4035:
4036: inv_mwb_query_manager.add_from_clause('po_headers_trx_v pha','INBOUND'); -- CLM project, bug 9403291
4037: inv_mwb_query_manager.add_where_clause(' pha.po_header_id = ms.po_header_id ','INBOUND');
4038: inv_mwb_query_manager.add_where_clause('pha.authorization_status = ''APPROVED''', 'INBOUND');
4039:
4040: /* IF inv_mwb_globals.g_include_po_without_asn = 1 THEN