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_HEADERS

Line 1778: FROM rcv_shipment_headers rsh

1774:
1775: l_mtl_location := document_type_meaning(4);
1776: SELECT shipment_num, shipped_date
1777: INTO l_shipment_num, l_shipped_date
1778: FROM rcv_shipment_headers rsh
1779: WHERE rsh.shipment_header_id = rec.shipment_header_id_asn;
1780:
1781: UPDATE mtl_mwb_gtmp
1782: SET document_number = l_shipment_num

Line 1838: FROM rcv_shipment_headers rsh

1834: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, rec.shipment_header_id_asn);
1835: l_mtl_location := document_type_meaning(3);
1836: UPDATE mtl_mwb_gtmp
1837: SET document_number = (SELECT shipment_num
1838: FROM rcv_shipment_headers rsh
1839: WHERE rsh.shipment_header_id = rec.shipment_header_id_asn)
1840: , document_type = l_mtl_location
1841: , document_type_id = 3
1842: WHERE shipment_header_id_asn = rec.shipment_header_id_asn;

Line 4077: inv_mwb_query_manager.add_from_clause(' rcv_shipment_headers rsh ','INBOUND');

4073: END IF;
4074:
4075: IF inv_mwb_globals.g_shipment_header_id_asn IS NOT NULL
4076: OR inv_mwb_globals.g_tree_doc_type_id IN (3,4) THEN
4077: inv_mwb_query_manager.add_from_clause(' rcv_shipment_headers rsh ','INBOUND');
4078: add_where_clause('rsh.shipment_header_id(+) = ms.shipment_header_id', 'INBOUND');
4079: END IF;
4080:
4081: IF inv_mwb_globals.g_shipment_header_id_asn IS NOT NULL THEN

Line 4260: inv_mwb_query_manager.add_from_clause(' rcv_shipment_headers rsh ','INBOUND');

4256: OR inv_mwb_globals.g_shipment_header_id_interorg IS NOT NULL THEN
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');

Line 4472: inv_mwb_query_manager.add_from_clause('rcv_shipment_headers rsh ','INBOUND');

4468: END IF;
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: