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.

APPS.GHG_TRANSACTIONS_API_PKG dependencies on GHG_SOURCES

Line 451: ghg_sources s

447: , v_emission_source_id
448: , v_emission_source_name
449: FROM GHG_SUPPLIER_ITEMS gsi,
450: mtl_system_items_kfv msi,
451: ghg_sources s
452: WHERE msi.CONCATENATED_SEGMENTS = p_item_number
453: AND msi.INVENTORY_ITEM_ID = gsi.INVENTORY_ITEM_ID
454: and gsi.SOURCE_ID = s.SOURCE_ID;
455: EXCEPTION

Line 488: from GHG_SOURCES

484: ELSE
485: BEGIN
486: SELECT source_id
487: into v_emission_source_id
488: from GHG_SOURCES
489: where source_name = nvl(p_emission_source_name, v_emission_source_name);
490: EXCEPTION
491: when no_data_found then
492: FND_MESSAGE.SET_NAME('GHG','GHG_SOURCE_UNKNOWN');

Line 610: FROM GHG_SOURCES xnes,

606: RAISE raise_error;
607: ELSE
608: SELECT count(*)
609: INTO v_check
610: FROM GHG_SOURCES xnes,
611: mtl_units_of_measure_tl mum1,
612: mtl_units_of_measure_tl mum2
613: WHERE mum1.unit_of_measure = xnes.unit_of_measure
614: AND mum2.uom_class = mum1.uom_class

Line 1014: clear_table('GHG_SOURCES_D', v_dblink);

1010: write_to_log('Cleardown Data Warehouse');
1011:
1012: clear_table('GHG_ASSETS_D', v_dblink);
1013: clear_table('GHG_EMISSION_SCOPES_D', v_dblink);
1014: clear_table('GHG_SOURCES_D', v_dblink);
1015: clear_table('GHG_ITEMS_D', v_dblink);
1016: clear_table('GHG_SUPPLIERS_D', v_dblink);
1017: clear_table('GHG_ORGANIZATION_HIERARCHIES_D', v_dblink);
1018: clear_table('GHG_ORG_HIERARCHY_STRUCTURES_D', v_dblink);

Line 1076: write_to_log('Inserting into GHG_SOURCES_D');

1072: ' WHERE LOOKUP_TYPE = ''GHG_EMISSION_SCOPE''' || ' AND LANGUAGE='||concat(''''||v_language||'','''');
1073:
1074: execute immediate v_stmt;
1075:
1076: write_to_log('Inserting into GHG_SOURCES_D');
1077: v_stmt :=
1078: 'INSERT INTO GHG_SOURCES_D@' || v_dblink ||
1079: ' ( ' ||
1080: 'SOURCE_APPLICATION_CODE, ' ||

Line 1078: 'INSERT INTO GHG_SOURCES_D@' || v_dblink ||

1074: execute immediate v_stmt;
1075:
1076: write_to_log('Inserting into GHG_SOURCES_D');
1077: v_stmt :=
1078: 'INSERT INTO GHG_SOURCES_D@' || v_dblink ||
1079: ' ( ' ||
1080: 'SOURCE_APPLICATION_CODE, ' ||
1081: 'SOURCE_ID, ' ||
1082: 'SOURCE_CODE, ' ||

Line 1141: 'from GHG_SOURCES_all src ' ||

1137: and val.flex_value_id = fltl.flex_value_id
1138: and val.flex_value = rcc.segment3 and tl.language= '||concat(''''||v_language||'','''')
1139: || ' and fltl.language= '||concat(''''||v_language||'','''')
1140: || ' and idf.application_column_name = '||'''SEGMENT3''' ||') segment3_desc '||
1141: 'from GHG_SOURCES_all src ' ||
1142: ', GHG_SOURCE_COMBINATIONS_ALL fac ' ||
1143: ', GHG_REPORT_COMBINATIONS rcc ' ||
1144: 'where fac.source_id = src.source_id ' ||
1145: 'and fac.code_combination_id = rcc.code_combination_id (+)';

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 1970: ', GHG_SOURCES_D@' || v_dblink || ' src ' ||

1966: 'initcap(kpd.den_type) denominator_value_type, ' ||
1967: ' (select meaning from fnd_lookup_values lv where lv.language='||concat(''''||v_language||'','''') || ' and lv.lookup_type = ''GHG_BI_TRANSACTION_TYPE'' and lv.lookup_code=''ACT'') transaction_type ' ||
1968: 'from GHG_KPI_DEFINITIONS_all kpd ' ||
1969: ', GHG_KPI_COMPONENTS kpc ' ||
1970: ', GHG_SOURCES_D@' || v_dblink || ' src ' ||
1971: ', GHG_TRANSACTIONS_D@' || v_dblink || ' trx ' ||
1972: ', GHG_UOM_CLASSES_all umn ' ||
1973: ', GHG_UOM_CLASSES_all umd ' ||
1974: 'where kpd.kpi_id = kpc.kpi_id ' ||

Line 2009: ', GHG_SOURCES_D@' || v_dblink || ' src ' ||

2005: 'initcap(kpd.den_type) denominator_value_type, ' ||
2006: '''Actuals'' transaction_type ' ||
2007: 'from GHG_KPI_DEFINITIONS_all kpd ' ||
2008: ', GHG_KPI_COMPONENTS kpc ' ||
2009: ', GHG_SOURCES_D@' || v_dblink || ' src ' ||
2010: ', GHG_TRANSACTIONS_D@' || v_dblink || ' trx ' ||
2011: ', GHG_UOM_CLASSES_all umn ' ||
2012: ', GHG_UOM_CLASSES_all umd ' ||
2013: 'where kpd.kpi_id = kpc.kpi_id ' ||