DBA Data[Home] [Help]

APPS.GMD_SPEC_VRS_GRP dependencies on PO_HEADERS_ALL

Line 3563: FROM po_headers_all pha

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

Line 3576: FROM po_headers_all pha, po_lines_all pla

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