eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_MWB_QUERY_MANAGER dependencies on RCV_SHIPMENT_LINES

Line 1791: FROM rcv_shipment_lines rsl

1787:
1788: IF rec.document_line_number IS NOT NULL THEN
1789: UPDATE mtl_mwb_gtmp
1790: SET document_line_number = (SELECT line_num
1791: FROM rcv_shipment_lines rsl
1792: WHERE rsl.shipment_line_id = rec.document_line_number)
1793: WHERE shipment_header_id_asn = rec.shipment_header_id_asn
1794: AND document_line_number = rec.document_line_number;
1795: END IF;

Line 1847: FROM rcv_shipment_lines rsl

1843:
1844: IF rec.document_line_number IS NOT NULL THEN
1845: UPDATE mtl_mwb_gtmp
1846: SET document_line_number = (SELECT line_num
1847: FROM rcv_shipment_lines rsl
1848: WHERE rsl.shipment_line_id = rec.document_line_number)
1849: WHERE shipment_header_id_asn = rec.shipment_header_id_asn
1850: AND document_line_number = rec.document_line_number;
1851: END IF;

Line 4088: inv_mwb_query_manager.add_from_clause(' rcv_shipment_lines rsl ','INBOUND');

4084: END IF;
4085:
4086: IF inv_mwb_globals.g_tree_parent_lpn_id IS NOT NULL
4087: OR inv_mwb_globals.g_tree_doc_type_id IN (3,4) THEN
4088: inv_mwb_query_manager.add_from_clause(' rcv_shipment_lines rsl ','INBOUND');
4089: add_where_clause('rsl.shipment_line_id = ms.shipment_line_id', 'INBOUND');
4090: END IF;
4091:
4092: IF inv_mwb_globals.g_tree_parent_lpn_id IS NOT NULL THEN

Line 4261: inv_mwb_query_manager.add_from_clause(' rcv_shipment_lines rsl ','INBOUND');

4257:
4258: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'Interorg tab');
4259:
4260: inv_mwb_query_manager.add_from_clause(' rcv_shipment_headers rsh ','INBOUND');
4261: inv_mwb_query_manager.add_from_clause(' rcv_shipment_lines rsl ','INBOUND');
4262:
4263: inv_mwb_query_manager.add_where_clause(' rsh.shipment_header_id(+) = ms.shipment_header_id ', 'INBOUND');
4264: inv_mwb_query_manager.add_where_clause(' rsl.shipment_line_id(+) = ms.shipment_line_id ', 'INBOUND');
4265: inv_mwb_query_manager.add_where_clause(' ms.supply_type_code IN (''REQ'',''SHIPMENT'') ', 'INBOUND');

Line 4473: inv_mwb_query_manager.add_from_clause('rcv_shipment_lines rsl ','INBOUND');

4469:
4470: ELSE -- If interorg and supplier tab null
4471:
4472: inv_mwb_query_manager.add_from_clause('rcv_shipment_headers rsh ','INBOUND');
4473: inv_mwb_query_manager.add_from_clause('rcv_shipment_lines rsl ','INBOUND');
4474: inv_mwb_query_manager.add_where_clause('rsh.shipment_header_id(+) = ms.shipment_header_id ', 'INBOUND');
4475: inv_mwb_query_manager.add_where_clause('rsl.shipment_line_id(+) = ms.shipment_line_id', 'INBOUND');
4476:
4477: IF inv_mwb_globals.g_organization_id IS NOT NULL THEN