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 1689: FROM rcv_shipment_lines rsl

1685:
1686: IF rec.document_line_number IS NOT NULL THEN
1687: UPDATE mtl_mwb_gtmp
1688: SET document_line_number = (SELECT line_num
1689: FROM rcv_shipment_lines rsl
1690: WHERE rsl.shipment_line_id = rec.document_line_number)
1691: WHERE shipment_header_id_asn = rec.shipment_header_id_asn
1692: AND document_line_number = rec.document_line_number;
1693: END IF;

Line 1745: FROM rcv_shipment_lines rsl

1741:
1742: IF rec.document_line_number IS NOT NULL THEN
1743: UPDATE mtl_mwb_gtmp
1744: SET document_line_number = (SELECT line_num
1745: FROM rcv_shipment_lines rsl
1746: WHERE rsl.shipment_line_id = rec.document_line_number)
1747: WHERE shipment_header_id_asn = rec.shipment_header_id_asn
1748: AND document_line_number = rec.document_line_number;
1749: END IF;

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

3380: END IF;
3381:
3382: IF inv_mwb_globals.g_tree_parent_lpn_id IS NOT NULL
3383: OR inv_mwb_globals.g_tree_doc_type_id IN (3,4) THEN
3384: inv_mwb_query_manager.add_from_clause(' rcv_shipment_lines rsl ','INBOUND');
3385: add_where_clause('rsl.shipment_line_id = ms.shipment_line_id', 'INBOUND');
3386: END IF;
3387:
3388: IF inv_mwb_globals.g_tree_parent_lpn_id IS NOT NULL THEN

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

3493:
3494: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'Interorg tab');
3495:
3496: inv_mwb_query_manager.add_from_clause(' rcv_shipment_headers rsh ','INBOUND');
3497: inv_mwb_query_manager.add_from_clause(' rcv_shipment_lines rsl ','INBOUND');
3498:
3499: inv_mwb_query_manager.add_where_clause(' rsh.shipment_header_id(+) = ms.shipment_header_id ', 'INBOUND');
3500: inv_mwb_query_manager.add_where_clause(' rsl.shipment_line_id(+) = ms.shipment_line_id ', 'INBOUND');
3501: inv_mwb_query_manager.add_where_clause(' ms.supply_type_code IN (''REQ'',''SHIPMENT'') ', 'INBOUND');

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

3646:
3647: ELSE -- If interorg and supplier tab null
3648:
3649: inv_mwb_query_manager.add_from_clause('rcv_shipment_headers rsh ','INBOUND');
3650: inv_mwb_query_manager.add_from_clause('rcv_shipment_lines rsl ','INBOUND');
3651: inv_mwb_query_manager.add_where_clause('rsh.shipment_header_id(+) = ms.shipment_header_id ', 'INBOUND');
3652: inv_mwb_query_manager.add_where_clause('rsl.shipment_line_id(+) = ms.shipment_line_id', 'INBOUND');
3653:
3654: IF inv_mwb_globals.g_organization_id IS NOT NULL THEN