3559: -- bug 4924483 sql id 14687791 - cost is down from 4,380,562 to 6 - no IN
3560:
3561: /*CURSOR c_po IS
3562: SELECT 1
3563: FROM po_headers_all pha
3564: WHERE pha.po_header_id IN
3565: (SELECT pla.po_header_id
3566: FROM po_lines_all pla
3567: WHERE pla.po_header_id = pha.po_header_id
3572:
3573: -- fix
3574: CURSOR c_po IS
3575: SELECT 1
3576: FROM po_headers_all pha, po_lines_all pla
3577: WHERE pha.po_header_id = p_supp_vr.po_header_id
3578: AND pha.vendor_id = p_supp_vr.supplier_id
3579: AND pha.vendor_site_id = p_supp_vr.supplier_site_id
3580: AND pha.po_header_id = pla.po_header_id