DBA Data[Home] [Help]

APPS.GMD_SPEC_VRS_GRP dependencies on PO_HEADERS_ALL

Line 3413: FROM po_headers_all pha

3409: -- bug 4924483 sql id 14687791 - cost is down from 4,380,562 to 6 - no IN
3410:
3411: /*CURSOR c_po IS
3412: SELECT 1
3413: FROM po_headers_all pha
3414: WHERE pha.po_header_id IN
3415: (SELECT pla.po_header_id
3416: FROM po_lines_all pla
3417: WHERE pla.po_header_id = pha.po_header_id

Line 3426: FROM po_headers_all pha, po_lines_all pla

3422:
3423: -- fix
3424: CURSOR c_po IS
3425: SELECT 1
3426: FROM po_headers_all pha, po_lines_all pla
3427: WHERE pha.po_header_id = p_supp_vr.po_header_id
3428: AND pha.vendor_id = p_supp_vr.supplier_id
3429: AND pha.vendor_site_id = p_supp_vr.supplier_site_id
3430: AND pha.po_header_id = pla.po_header_id