DBA Data[Home] [Help]

APPS.GMD_SPEC_VRS_GRP dependencies on PO_LINES_ALL

Line 3416: FROM po_lines_all pla

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
3418: AND pla.item_id = p_spec.inventory_item_id
3419: AND pha.vendor_id = p_supp_vr.supplier_id
3420: AND pha.vendor_site_id = p_supp_vr.supplier_site_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

Line 3440: FROM po_lines_all pla

3436:
3437:
3438: CURSOR c_po_line IS
3439: SELECT 1
3440: FROM po_lines_all pla
3441: WHERE pla.item_id = p_spec.inventory_item_id
3442: AND pla.po_header_id = p_supp_vr.po_header_id
3443: AND pla.po_line_id = p_Supp_vr.po_line_id;
3444: