DBA Data[Home] [Help]

APPS.INV_MWB_QUERY_MANAGER dependencies on PO_LINES_ALL

Line 1707: FROM po_lines_all pla

1703:
1704: IF rec.document_line_number IS NOT NULL THEN
1705: UPDATE mtl_mwb_gtmp
1706: SET document_line_number = (SELECT line_num
1707: FROM po_lines_all pla
1708: WHERE pla.po_line_id = rec.document_line_number)
1709: WHERE po_header_id = rec.po_header_id
1710: AND document_line_number = rec.document_line_number;
1711: END IF;

Line 3354: inv_mwb_query_manager.add_from_clause('po_lines_all pla ','INBOUND');

3350: END IF;
3351: END IF;
3352:
3353: IF inv_mwb_globals.g_vendor_item IS NOT NULL THEN
3354: inv_mwb_query_manager.add_from_clause('po_lines_all pla ','INBOUND');
3355: inv_mwb_query_manager.add_where_clause('ms.po_line_id = pla.po_line_id', 'INBOUND');
3356: inv_mwb_query_manager.add_where_clause('pla.vendor_product_num = :inb_vendor_item', 'INBOUND');
3357: add_bind_variable('inb_vendor_item', inv_mwb_globals.g_vendor_item);
3358: END IF;