DBA Data[Home] [Help]

APPS.GMD_SPEC_VRS_GRP dependencies on PO_LINES_ALL

Line 3566: FROM po_lines_all pla

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
3568: AND pla.item_id = p_spec.inventory_item_id
3569: AND pha.vendor_id = p_supp_vr.supplier_id
3570: AND pha.vendor_site_id = p_supp_vr.supplier_site_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

Line 3590: FROM po_lines_all pla

3586:
3587:
3588: CURSOR c_po_line IS
3589: SELECT 1
3590: FROM po_lines_all pla
3591: WHERE pla.item_id = p_spec.inventory_item_id
3592: AND pla.po_header_id = p_supp_vr.po_header_id
3593: AND pla.po_line_id = p_Supp_vr.po_line_id;
3594: