APPS.INV_RCV_STD_INSPECT_APIS dependencies on OE_ORDER_LINES_ALL

Line 5306: ,oe_order_lines_all oel

5302: ,po_line_locations pll
5303: ,po_lines pol
5304: ,mtl_system_items msi
5305: ,mtl_customer_items mci
5306: ,oe_order_lines_all oel
5307: WHERE rt.transaction_id = l_rcv_transaction_id
5308: AND rt.transaction_type <> 'UNORDERED'
5309: AND rsup.supply_type_code = 'RECEIVING'
5310: AND rsup.rcv_transaction_id = rt.transaction_id

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