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 PO_HEADERS_ALL

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)