APPS.INV_RCV_STD_INSPECT_APIS dependencies on PO_HEADERS

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)

Line 4661: FROM po_asl_suppliers_v pasv, po_lines pl, po_headers ph

4657: begin
4658: -- get ASL -- query provided by jenny zheng from QA team
4659: SELECT pasv.asl_status_id, pasv.asl_status_dsp
4660: into x_asl_status_id, x_asl_status_dsp
4661: FROM po_asl_suppliers_v pasv, po_lines pl, po_headers ph
4662: WHERE pl.item_id = pasv.item_id
4663: AND pl.po_line_id = v_po_line_id -- here use the variable from above
4664: AND pl.po_header_id = ph.po_header_id
4665: AND ph.vendor_id(+) = pasv.vendor_id