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_LOGICAL_TRANSACTIONS_PUB dependencies on MTL_SALES_ORDERS

Line 1929: FROM oe_order_headers_all oeh, mtl_sales_orders mso

1925:
1926: l_progress := 240;
1927: SELECT mso.sales_order_id
1928: INTO l_mtl_trx_tbl(1).transaction_source_id
1929: FROM oe_order_headers_all oeh, mtl_sales_orders mso
1930: WHERE to_char(oeh.order_number) = mso.segment1
1931: AND mso.segment2 = l_oe_order_type_name
1932: AND mso.segment3 = l_order_source
1933: AND oeh.header_id = l_oe_header_id;

Line 1945: mtl_sales_orders mso,

1941: INTO l_mtl_trx_tbl(1).trx_source_line_id,
1942: l_mtl_trx_tbl(1).transaction_source_id
1943: FROM oe_drop_ship_sources odss,
1944: rcv_transactions rt,
1945: mtl_sales_orders mso,
1946: oe_order_headers_all ooha
1947: WHERE rt.transaction_id = l_mtl_trx_tbl(1).rcv_transaction_id
1948: AND odss.line_location_id = rt.po_line_location_id
1949: AND odss.header_id = ooha.header_id

Line 1956: FROM mtl_sales_orders mso,

1952: ******/
1953: /*****
1954: SELECT mso.sales_order_id
1955: INTO l_mtl_trx_tbl(1).transaction_source_id
1956: FROM mtl_sales_orders mso,
1957: oe_order_headers_all ooha,
1958: oe_order_lines_all oola
1959: WHERE oola.line_id = l_mtl_trx_tbl(1).trx_source_line_id
1960: AND oola.header_id = ooha.header_id