APPS.GMF_SYNC_VENDOR SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 9

    v_last_update_date           date;

Line: 27

    select decode(upper(f.multi_org_flag), 'Y', p.org_id, NULL)
    from gl_plcy_mst p,
         fnd_product_groups f
    where p.co_code=p_co_code;

Line: 35

    select i.last_update_date, i.vendor_id, i.vendor_site_code
    from po_vendor_sites_all i
    where nvl(i.org_id,-999) = nvl(v_org_id,-999)
    for update of last_update_date;

Line: 43

	 select v.segment1
	 from po_vendors v
	 where v.vendor_id = p_vendor_id;

Line: 82

        fetch c_po_vendor_sites_all into v_last_update_date,v_vendor_id	,v_vendor_site_code ;

Line: 98

        update po_vendor_sites_all
        set last_update_date=last_update_date
        where  current of c_po_vendor_sites_all;