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_RCV_STD_INSPECT_APIS dependencies on OE_SOLD_TO_ORGS_V

Line 4748: from mtl_txn_request_lines mtrl, oe_order_lines_all oel, oe_order_headers_all oeh, oe_sold_to_orgs_v oest

4744: x_msg_data := ' ';
4745:
4746: select distinct oeh.header_id, oeh.order_number, oest.customer_id, oest.customer_number, oest.name
4747: into x_rma_id, x_rma_number, x_customer_id, x_customer_number, x_customer_name
4748: from mtl_txn_request_lines mtrl, oe_order_lines_all oel, oe_order_headers_all oeh, oe_sold_to_orgs_v oest
4749: where reference = 'ORDER_LINE_ID'
4750: and mtrl.reference_id = oel.line_id
4751: and mtrl.quantity > nvl(mtrl.quantity_delivered, 0)
4752: and oel.header_id = oeh.header_id