APPS.INV_RCV_STD_INSPECT_APIS dependencies on OE_ORDER_HEADERS_ALL

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

6623: --BUG 3444196: Modify the following query to avoid the
6624: --'Non-mergable view exists for the following SQL' complaints
6625: SELECT COUNT(DISTINCT oeh.header_id)
6626: INTO v_count_rma
6627: FROM mtl_txn_request_lines mtrl, oe_order_lines_all oel, oe_order_headers_all oeh
6628: WHERE reference = 'ORDER_LINE_ID'
6629: AND mtrl.reference_id = oel.line_id
6630: AND mtrl.quantity > nvl(mtrl.quantity_delivered, 0)
6631: AND oel.header_id = oeh.header_id

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

6643: x_msg_data := ' ';
6644:
6645: select distinct oeh.header_id, oeh.order_number, oest.customer_id, oest.customer_number, oest.name
6646: into x_rma_id, x_rma_number, x_customer_id, x_customer_number, x_customer_name
6647: from mtl_txn_request_lines mtrl, oe_order_lines_all oel, oe_order_headers_all oeh, oe_sold_to_orgs_v oest
6648: where reference = 'ORDER_LINE_ID'
6649: and mtrl.reference_id = oel.line_id
6650: and mtrl.quantity > nvl(mtrl.quantity_delivered, 0)
6651: and oel.header_id = oeh.header_id