APPS.INV_RCV_STD_INSPECT_APIS dependencies on PO_LINE_LOCATIONS

Line 3402: ,po_line_locations pll

3398: FROM rcv_supply rsup
3399: ,rcv_shipment_headers rsh
3400: ,rcv_shipment_lines rsl
3401: ,rcv_transactions rt
3402: ,po_line_locations pll
3403: ,po_lines pol
3404: ,mtl_system_items msi
3405: ,mtl_customer_items mci
3406: ,oe_order_lines_all oel

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

4609: --BUG 3444196: Modify the following query to avoid the
4610: --'Non-mergable view exists for the following SQL' complaints
4611: SELECT COUNT(DISTINCT pha.po_header_id)
4612: INTO v_count_po
4613: FROM mtl_txn_request_lines mtrl, po_line_locations_all plla, po_headers_all pha
4614: WHERE reference = 'PO_LINE_LOCATION_ID'
4615: AND mtrl.reference_id = plla.line_location_id
4616: AND plla.po_header_id = pha.po_header_id
4617: AND mtrl.quantity > nvl(mtrl.quantity_delivered, 0)

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

4633: x_msg_data := ' ';
4634:
4635: select distinct pha.po_header_id, pha.segment1, pv.vendor_id, pv.vendor_name, plla.po_line_id
4636: into x_po_id, x_po_number, x_vendor_id, x_vendor_name, v_po_line_id
4637: from mtl_txn_request_lines mtrl, po_line_locations_all plla, po_headers_all pha, po_vendors pv
4638: where reference = 'PO_LINE_LOCATION_ID'
4639: and mtrl.reference_id = plla.line_location_id
4640: and plla.po_header_id = pha.po_header_id
4641: and mtrl.quantity > nvl(mtrl.quantity_delivered, 0)