APPS.INV_RCV_STD_INSPECT_APIS dependencies on PO_LINE_LOCATIONS

Line 5302: ,po_line_locations pll

5298: FROM rcv_supply rsup
5299: ,rcv_shipment_headers rsh
5300: ,rcv_shipment_lines rsl
5301: ,rcv_transactions rt
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

Line 6512: FROM mtl_txn_request_lines mtrl, po_line_locations_all plla, po_headers_all pha

6508: --BUG 3444196: Modify the following query to avoid the
6509: --'Non-mergable view exists for the following SQL' complaints
6510: SELECT COUNT(DISTINCT pha.po_header_id)
6511: INTO v_count_po
6512: FROM mtl_txn_request_lines mtrl, po_line_locations_all plla, po_headers_all pha
6513: WHERE reference = 'PO_LINE_LOCATION_ID'
6514: AND mtrl.reference_id = plla.line_location_id
6515: AND plla.po_header_id = pha.po_header_id
6516: AND mtrl.quantity > nvl(mtrl.quantity_delivered, 0)

Line 6536: from mtl_txn_request_lines mtrl, po_line_locations_all plla, po_headers_all pha, po_vendors pv

6532: x_msg_data := ' ';
6533:
6534: select distinct pha.po_header_id, pha.segment1, pv.vendor_id, pv.vendor_name, plla.po_line_id
6535: into x_po_id, x_po_number, x_vendor_id, x_vendor_name, v_po_line_id
6536: from mtl_txn_request_lines mtrl, po_line_locations_all plla, po_headers_all pha, po_vendors pv
6537: where reference = 'PO_LINE_LOCATION_ID'
6538: and mtrl.reference_id = plla.line_location_id
6539: and plla.po_header_id = pha.po_header_id
6540: and mtrl.quantity > nvl(mtrl.quantity_delivered, 0)