APPS.INV_RCV_STD_INSPECT_APIS dependencies on PO_HEADERS

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)

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

6556: begin
6557: -- get ASL -- query provided by jenny zheng from QA team
6558: SELECT pasv.asl_status_id, pasv.asl_status_dsp
6559: into x_asl_status_id, x_asl_status_dsp
6560: FROM po_asl_suppliers_v pasv, po_lines pl, po_headers ph
6561: WHERE pl.item_id = pasv.item_id
6562: AND pl.po_line_id = v_po_line_id -- here use the variable from above
6563: AND pl.po_header_id = ph.po_header_id
6564: AND ph.vendor_id(+) = pasv.vendor_id