eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.GHG_TRANSACTIONS_API_PKG dependencies on STANDARD

Line 1569: ', (select cl.STANDARD_UOM from GHG_SOURCES src, GHG_UOM_CLASSES cl where src.source_id = tr.transaction_source_id and src.ghg_uom_class_code = cl.ghg_uom_class_code) emission_source_usage_uom ' ||

1565: ', ap.invoice_currency_code transaction_currency_code ' ||
1566: ', cur.name transaction_currency_desc ' ||
1567: ', em.source_combination_id transaction_source_id ' ||
1568: ', ((nvl(tr.usage_quantity,0)* ghg_utilities_pkg.get_conversion(tr.unit_of_measure, tr.transaction_source_id, ''STDUOM'', ''ETL''))/((tr.transaction_date_to-tr.transaction_date_from)+1)) emission_source_usage_quantity ' ||
1569: ', (select cl.STANDARD_UOM from GHG_SOURCES src, GHG_UOM_CLASSES cl where src.source_id = tr.transaction_source_id and src.ghg_uom_class_code = cl.ghg_uom_class_code) emission_source_usage_uom ' ||
1570: ', tr.emission_scope_lookup_code emission_scope_id ' ||
1571: ', (select meaning from fnd_lookup_values_vl lv where lookup_type = ''GHG_EMISSION_TYPE'' and tr.transaction_type_lookup_code = lv.lookup_code) energy_type ' ||
1572: ', nvl(tr.energy_quantity,0)/((tr.transaction_date_to-tr.transaction_date_from)+1) energy_quantity ' ||
1573: ', ''GJ'' energy_uom ' ||

Line 1948: '''USAGE'', umn.STANDARD_UOM, ' ||

1944: 'kpd.kpi_id kpi_id, ' ||
1945: 'trx.transaction_date kpi_date, ' ||
1946: 'trx.ORGANIZATION_id ORGANIZATION_id, ' ||
1947: 'decode( kpd.num_type, ' ||
1948: '''USAGE'', umn.STANDARD_UOM, ' ||
1949: '''ENERGY'', trx.energy_uom, ' ||
1950: '''EMISSIONS'', trx.co2_e_uom, ' ||
1951: '''VALUE'', trx.transaction_currency_code, '''') numerator_uom, ' ||
1952: 'decode( kpd.num_type, ' ||

Line 1959: '''USAGE'', umd.STANDARD_UOM, ' ||

1955: '''EMISSIONS'', nvl(trx.co2_e_quantity,0), ' ||
1956: '''VALUE'', nvl(trx.transaction_value,0),0) numerator_value, ' ||
1957: 'kpd.num_function numerator_action, ' ||
1958: 'decode( kpd.den_type, ' ||
1959: '''USAGE'', umd.STANDARD_UOM, ' ||
1960: '''ENERGY'', trx.energy_uom, ' ||
1961: '''EMISSIONS'', trx.co2_e_uom, ' ||
1962: '''VALUE'', trx.transaction_currency_code, '''') denominator_uom, ' ||
1963: '0 denominator_value, ' ||

Line 1987: '''USAGE'', umn.STANDARD_UOM, ' ||

1983: 'kpd.kpi_id kpi_id, ' ||
1984: 'trx.transaction_date kpi_date, ' ||
1985: 'trx.ORGANIZATION_id ORGANIZATION_id, ' ||
1986: 'decode( kpd.num_type, ' ||
1987: '''USAGE'', umn.STANDARD_UOM, ' ||
1988: '''ENERGY'', trx.energy_uom, ' ||
1989: '''EMISSIONS'', trx.co2_e_uom, ' ||
1990: '''VALUE'', trx.transaction_currency_code, '''') numerator_uom, ' ||
1991: '0 numerator_value, ' ||

Line 1994: '''USAGE'', umd.STANDARD_UOM, ' ||

1990: '''VALUE'', trx.transaction_currency_code, '''') numerator_uom, ' ||
1991: '0 numerator_value, ' ||
1992: 'kpd.num_function numerator_action, ' ||
1993: 'decode( kpd.den_type, ' ||
1994: '''USAGE'', umd.STANDARD_UOM, ' ||
1995: '''ENERGY'', trx.energy_uom, ' ||
1996: '''EMISSIONS'', trx.co2_e_uom, ' ||
1997: '''VALUE'', trx.transaction_currency_code, '''') denominator_uom, ' ||
1998: 'decode( kpd.den_type, ' ||