APPS.PO_VENDORS_SV SQL Statements

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

Line: 23

  SELECT vendor_id
  INTO   X_vendor_id_v
  FROM   po_vendors
  WHERE  sysdate between nvl(start_date_active, sysdate -1)
  AND    nvl(end_date_active, sysdate + 1)
  AND    enabled_flag = 'Y'
  AND    vendor_id = X_vendor_id;

Line: 69

          cursor C is select v.type_1099,
                      v.hold_flag,
                      null,
                      null,
                      null,
                      null,
                      null,
                      v.terms_id,
                      v.invoice_currency_code,
                      v.receipt_required_flag,
                      v.num_1099,
                      v.vat_registration_num,
                      v.inspection_required_flag
                from  po_vendors    v
                where v.vendor_id = X_vendor_id;

Line: 397

                   select lookup_code
                   into  X_res_fob
                   from   po_lookup_codes
                   where  lookup_type = x_lookup_type
                   and    sysdate < nvl(inactive_date, sysdate + 1)
                   and    lookup_code = X_temp_fob_lookup_code;

Line: 435

              SELECT lookup_code
              INTO   X_res_freight_terms
              FROM   po_lookup_codes
              WHERE  lookup_type = x_lookup_type
              AND    sysdate < nvl(inactive_date, sysdate + 1)
              AND    lookup_code = X_temp_freight_terms  ;

Line: 469

            SELECT freight_code
            INTO   X_res_ship_via
            FROM   org_freight
            WHERE  organization_id = X_org_id
            AND    freight_code    = X_temp_ship_via
            AND    nvl(disable_date, sysdate + 1) > sysdate;

Line: 516

    SELECT lookup_code
      INTO x_res_shipping_control
      FROM po_lookup_codes
     WHERE lookup_type = x_lookup_type
       AND TRUNC(SYSDATE) < NVL( TRUNC(inactive_date), SYSDATE + 1 )
       AND lookup_code = p_temp_shipping_control;

Line: 561

    SELECT    terms_id,
              ship_via_lookup_code,
              fob_lookup_code,
              freight_terms_lookup_code,
              shipping_control    -- 
    INTO      x_terms_id,
              x_ship_via_lookup_code,
              x_fob_lookup_code,
              x_freight_terms_lookup_code,
              x_shipping_control    -- 
    FROM      po_headers_all
    WHERE     po_header_id = p_po_header_id;

Line: 621

            select displayed_field
            into   X_fob_dsp
            from   po_lookup_codes
            where  lookup_type = 'FOB'
            and    sysdate < nvl(inactive_date, sysdate + 1)
            and    lookup_code = X_res_fob;

Line: 650

            select displayed_field
            into   X_freight_terms_dsp
            from   po_lookup_codes
            where  lookup_type = 'FREIGHT TERMS'
            and    sysdate < nvl(inactive_date, sysdate + 1)
            and    lookup_code = X_res_freight_terms  ;

Line: 675

             select  description
             into    X_ship_via_dsp
             from    org_freight
             where  organization_id = X_org_id
             and    freight_code    = X_res_ship_via
             and    nvl(disable_date, sysdate + 1) > sysdate;

Line: 700

            select name
            into   X_terms_dsp
            from ap_terms
            where term_id = X_res_terms_id;

Line: 736

    SELECT    name
    INTO      x_terms_dsp
    FROM      ap_terms
    WHERE     term_id = p_terms_id;

Line: 768

          /* select location_code
           into   X_ship_to_loc_dsp
           from   hr_locations
           where  location_id = X_temp_ship_to_loc_id;*/

Line: 780

        /*   select ood.organization_code,
                  ood.organization_name,
                  ood.organization_id
          into    X_ship_org_code,
                  X_ship_org_name,
                  X_ship_org_id
          from org_organization_definitions ood,
               hr_locations hrl
          where hrl.ship_to_location_id = X_temp_ship_to_loc_id
          and   hrl.inventory_organization_id = ood.organization_id(+)
          and   ( ood.set_of_books_id IS NULL
                 or ood.set_of_books_id = X_set_of_books_id);  */

Line: 795

         /* select ood.organization_code,
                  ood.organization_name,
                  ood.organization_id
          into    X_ship_org_code,
                  X_ship_org_name,
                  X_ship_org_id
          from org_organization_definitions ood
          where ood.organization_id(+) = X_inv_org_id
          and   ( ood.set_of_books_id IS NULL
                 or ood.set_of_books_id = X_set_of_books_id);*/

Line: 848

           /*  select location_code
             into   X_bill_to_loc_dsp
             from   hr_locations
             where  location_id = X_temp_bill_to_loc_id; */

Line: 888

         SELECT POV.vendor_name
         FROM   PO_VENDORS POV
         WHERE  POV.vendor_id = X_vendor_id;

Line: 956

        SELECT pov.vendor_name
        INTO   X_vendor_name
        FROM   po_vendors pov
        WHERE  pov.vendor_id = X_vendor_id;

Line: 1031

    sql_str := 'select pov.vendor_name, pov.vendor_id, pov.segment1 from po_vendors pov where ';

Line: 1165

 X_sql_str varchar2(2000) := 'SELECT pov.start_date_active, pov.end_date_active, pov.enabled_flag, pov.hold_flag FROM po_vendors pov where ';