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_ORDER_HEADERS_ALL

Line 4728: FROM mtl_txn_request_lines mtrl, oe_order_lines_all oel, oe_order_headers_all oeh

4724: --BUG 3444196: Modify the following query to avoid the
4725: --'Non-mergable view exists for the following SQL' complaints
4726: SELECT COUNT(DISTINCT oeh.header_id)
4727: INTO v_count_rma
4728: FROM mtl_txn_request_lines mtrl, oe_order_lines_all oel, oe_order_headers_all oeh
4729: WHERE reference = 'ORDER_LINE_ID'
4730: AND mtrl.reference_id = oel.line_id
4731: AND mtrl.quantity > nvl(mtrl.quantity_delivered, 0)
4732: AND oel.header_id = oeh.header_id

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