DBA Data[Home] [Help]

APPS.INV_MWB_QUERY_MANAGER dependencies on PO_LINES_TRX_V

Line 1809: FROM po_lines_trx_v pla -- CLM project, bug 9403291

1805:
1806: IF rec.document_line_number IS NOT NULL THEN
1807: UPDATE mtl_mwb_gtmp
1808: SET document_line_number = (SELECT to_char(line_num)
1809: FROM po_lines_trx_v pla -- CLM project, bug 9403291
1810: WHERE pla.po_line_id = rec.document_line_number)
1811: WHERE po_header_id = rec.po_header_id
1812: AND document_line_number = rec.document_line_number;
1813: END IF;

Line 4058: inv_mwb_query_manager.add_from_clause('po_lines_trx_v pla ','INBOUND'); -- CLM project, bug 9403291

4054: END IF;
4055: END IF;
4056:
4057: IF inv_mwb_globals.g_vendor_item IS NOT NULL THEN
4058: inv_mwb_query_manager.add_from_clause('po_lines_trx_v pla ','INBOUND'); -- CLM project, bug 9403291
4059: inv_mwb_query_manager.add_where_clause('ms.po_line_id = pla.po_line_id', 'INBOUND');
4060: inv_mwb_query_manager.add_where_clause('pla.vendor_product_num = :inb_vendor_item', 'INBOUND');
4061: add_bind_variable('inb_vendor_item', inv_mwb_globals.g_vendor_item);
4062: END IF;