APPS.GHG_UTILITIES_PKG SQL Statements

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

Line: 11

  select org_id
  into   v_org_id
  from   ap_invoices_all
  where invoice_id = x_invoice_id;

Line: 19

  SELECT count(*)
  INTO   v_row_count
  FROM   GHG_TRANSACTIONS_V
  WHERE  invoice_id = x_invoice_id;

Line: 51

   select x.uom_class,
          x.base_uom_flag
   into   v_uom_class,
          v_uom_base
   from   mtl_units_of_measure_vl x
   where  unit_of_measure = x_from_uom;

Line: 65

    select unit_of_measure
    into v_from_emission_rate_uom
    from mtl_units_of_measure_vl
    where uom_class = v_uom_profile
    and   base_uom_flag = 'Y';

Line: 71

    SELECT muc.conversion_rate
    INTO   v_from_emission_conv_rate
    FROM   mtl_units_of_measure_vl mum1,
           mtl_uom_conversions muc
    WHERE  mum1.unit_of_measure = v_from_emission_rate_uom
    AND    muc.unit_of_measure = mum1.unit_of_measure;

Line: 79

    SELECT muc.conversion_rate
    INTO   v_emission_conv_rate
    FROM   mtl_units_of_measure_vl mum1,
           mtl_uom_conversions muc
    WHERE  mum1.unit_of_measure = x_from_uom
    AND    muc.unit_of_measure = mum1.unit_of_measure;

Line: 97

    SELECT xner.unit_of_measure,
           mum2.unit_of_measure
    INTO   v_from_emission_rate_uom,
           v_base_uom
    FROM   GHG_SUPPLIER_FACTORS_V xner,
           mtl_units_of_measure_vl mum1,
           mtl_units_of_measure_vl mum2
    WHERE  xner.COMBINATION_OVERRIDE_TYPE = 'Supplier'
    AND    xner.SOURCE_COMBINATION_ID = x_from_emission_source_id
    AND    mum1.unit_of_measure = xner.unit_of_measure
    AND    mum2.uom_class = mum1.uom_class
    AND    mum2.base_uom_flag = 'Y';

Line: 114

    SELECT xner.unit_of_measure,
           mum2.unit_of_measure
    INTO   v_from_emission_rate_uom,
           v_base_uom
    FROM   GHG_ITEM_FACTORS_V xner,
           mtl_units_of_measure_vl mum1,
           mtl_units_of_measure_vl mum2
    WHERE  xner.COMBINATION_OVERRIDE_TYPE = 'Item'
    AND    xner.SOURCE_COMBINATION_ID = x_from_emission_source_id
    AND    mum1.unit_of_measure = xner.unit_of_measure
    AND    mum2.uom_class = mum1.uom_class
    AND    mum2.base_uom_flag = 'Y';

Line: 128

    select mum1.unit_of_measure,
           mum2.unit_of_measure
    INTO   v_from_emission_rate_uom,
           v_base_uom
    from   GHG_SOURCES_ALL xnes,
      --bug 13451779 (sasuren) : changed from GHG_SOURCES to GHG_SOURCES_ALL
           GHG_UOM_CLASSES        class,
           mtl_units_of_measure_vl mum1,
           mtl_units_of_measure_vl mum2
    where  xnes.source_id = x_from_emission_source_id
    and    xnes.ghg_uom_class_code = class.ghg_uom_class_code
    and    mum1.unit_of_measure = class.STANDARD_UOM
    and    mum2.unit_of_measure = x_from_uom
    AND    mum2.uom_class = mum1.uom_class;

Line: 148

    SELECT xnes.unit_of_measure,
           mum2.unit_of_measure
    INTO   v_from_emission_rate_uom,
           v_base_uom
    FROM   GHG_SOURCES xnes,
           mtl_units_of_measure_vl mum1,
           mtl_units_of_measure_vl mum2
    WHERE  xnes.source_id = x_from_emission_source_id
    AND    mum1.unit_of_measure = xnes.unit_of_measure
    AND    mum2.uom_class = mum1.uom_class
    AND    mum2.base_uom_flag = 'Y';

Line: 166

    SELECT muc.conversion_rate
    INTO   v_from_emission_conv_rate
    FROM   mtl_units_of_measure_vl mum1,
           mtl_uom_conversions muc
    WHERE  mum1.unit_of_measure = v_from_emission_rate_uom
    AND    muc.unit_of_measure = mum1.unit_of_measure;

Line: 174

    SELECT muc.conversion_rate
    INTO   v_emission_conv_rate
    FROM   mtl_units_of_measure_vl mum1,
           mtl_uom_conversions muc
    WHERE  mum1.unit_of_measure = x_from_uom
    AND    muc.unit_of_measure = mum1.unit_of_measure;

Line: 221

  SELECT count(*)
  into   V_ROW_COUNT
  from   GHG_SUPPLIER_ITEMS
  where  SUPPLIER_ID = X_VENDOR_ID
  AND    supplier_site_id = x_vendor_site_id;

Line: 237

  SELECT ai.org_id,
	 ai.gl_date,
         ai.vendor_id ,
         ai.vendor_site_id,
         ai.invoice_num,
         aid.distribution_line_number,
         aid.invoice_line_number,
         aid.amount,
         aid.dist_code_combination_id  code_combination_id,
         aid.project,
         aid.task,
         aid.po_number
  FROM   ap_invoices_all ai,
         ap_invoice_distributions_v aid,
         fnd_lookup_values_vl xnlv
  WHERE  ai.invoice_id = p_invoice_id
  AND    aid.invoice_id = ai.invoice_id
  AND    xnlv.lookup_code = aid.line_type_lookup_code
  AND    xnlv.lookup_type = 'GHG_EMISSION_LINE_TYPES'
  AND    SYSDATE BETWEEN NVL(xnlv.start_date_active, SYSDATE - 1)
                 AND     NVL(xnlv.end_date_active, SYSDATE + 1) ;

Line: 273

 select org_id
 into   v_org_id
 from   ap_invoices_all
 where invoice_id = x_invoice_id;

Line: 281

  SELECT asp.set_of_books_id,
         gsob.chart_of_accounts_id
  INTO   v_set_of_books_id,
         v_chart_of_accounts_id
  FROM   ap_system_parameters asp,
         gl_sets_of_books gsob
  WHERE  gsob.set_of_books_id = asp.set_of_books_id;

Line: 292

  SELECT map_accounts_flag,
         map_operating_unit_flag,
         map_projects_flag
  INTO   v_map_accounts_flag,
         v_map_operating_unit_flag,
         v_map_projects_flag
  FROM   GHG_SEGMENT_MAPPINGS_V;

Line: 365

 SELECT SOURCE_NAME
 INTO   vl_emission_source
 FROM   GHG_SUPPLIER_ITEMS sd
 ,      GHG_SOURCES es
 WHERE  es.source_id = sd.source_id
 AND    sd.supplier_id = x_supplier_id
 AND    sd.supplier_site_id = x_supplier_site_id
 AND    es.enabled= 'Y';

Line: 386

         select a.invoice_id
         ,      a.vendor_id
         ,      a.vendor_site_id
         ,      p.segment1 po_number
         ,      a.org_id
         from   ap_invoices_all a
         ,      ap_invoice_lines_all b
         ,      po_headers_all p
         where  a.invoice_id = b.invoice_id
         and    b.po_header_id = p.po_header_id
         and    a.cancelled_date is null
         and    a.invoice_id = x_invoice_id;

Line: 402

    V_LAST_UPDATE_LOGIN    NUMBER        := -1;

Line: 417

                                                 X_LAST_UPDATE_LOGIN => V_LAST_UPDATE_LOGIN,
                                                 X_MESG => V_MESG,
                                                 x_measurement_criteria => 'A',
                                                 x_org_id => PO_RECS.ORG_ID );

Line: 430

  select sum(amount)
  into   vl_invoice_total
  from   ap_invoice_distributions_v v
  where  invoice_id = x_invoice_id
  and    nvl(reversal_flag,'N') <> 'Y'
  and    line_type_lookup_code in
                      (SELECT LOOKUP_CODE
                       FROM   FND_LOOKUPS
                       WHERE  lookup_type = 'GHG_EMISSION_LINE_TYPES'
                       AND    trunc(sysdate) between trunc(start_date_active) and
                                             trunc(nvl(end_date_active, GHG_UTILITIES_PKG.end_date	 ))
                      );

Line: 443

  select amount/vl_invoice_total
  into   vl_inv_perc
  from   ap_invoice_distributions_v
  where  invoice_id = x_invoice_id
  and    distribution_line_number = x_dist_line_num
  and    invoice_line_number = x_inv_line_num;

Line: 460

 SELECT 'Y'
 INTO   vl_result
 FROM   GHG_SUPPLIER_ITEMS
 WHERE  inventory_item_id = x_item_id;