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 FND_LOOKUP_VALUES

Line 43: FROM fnd_lookup_values_vl

39: -- Internal Invoices Batches Cannot be entered through API.
40: x_debug('Check Internal Invoices Batches Cannot be entered through API.');
41: SELECT count(*)
42: INTO v_row_count
43: FROM fnd_lookup_values_vl
44: WHERE upper(lookup_type) = 'GHG_INTERNAL_TXN_TYPE'
45: AND TRUNC(SYSDATE) BETWEEN start_date_active
46: AND NVL(end_date_active,GHG_utilities_pkg.end_date)
47: AND lookup_code = p_batch_type;

Line 62: FROM fnd_lookup_values_vl

58: x_debug('Check Input Batch SubType');
59: IF p_batch_sub_type IS NOT NULL THEN
60: SELECT count(*)
61: INTO v_row_count
62: FROM fnd_lookup_values_vl
63: WHERE upper(lookup_type) = 'GHG_TXN_SUB_TYPE'
64: AND TRUNC(SYSDATE) BETWEEN start_date_active
65: AND NVL(end_date_active,GHG_utilities_pkg.end_date)
66: AND lookup_code = p_batch_sub_type;

Line 133: FROM fnd_lookup_values_vl

129: -- Check Emission Scope
130: x_debug(' Check Emission Scope');
131: SELECT count(*)
132: INTO v_row_count
133: FROM fnd_lookup_values_vl
134: WHERE upper(lookup_type) = 'GHG_EMISSION_SCOPE'
135: AND TRUNC(SYSDATE) BETWEEN start_date_active AND NVL(end_date_active,GHG_utilities_pkg.end_date)
136: AND lookup_code = nvl(p_emission_scope, 'NA');
137:

Line 149: FROM fnd_lookup_values_vl

145: -- Check Measurement Criteria
146: x_debug('Check Measurement Criteria');
147: SELECT count(*)
148: INTO v_row_count
149: FROM fnd_lookup_values_vl
150: WHERE upper(lookup_type) = 'GHG_MEASUREMENT_CRITERIA'
151: AND TRUNC(SYSDATE) BETWEEN start_date_active
152: AND NVL(end_date_active,GHG_utilities_pkg.end_date)
153: AND lookup_code = nvl(p_m_criteria,'-1');

Line 204: FROM fnd_lookup_values_vl

200: IF p_emission_location is NOT NULL THEN
201: x_debug('Validating emission location');
202: SELECT count(*)
203: INTO v_row_count
204: FROM fnd_lookup_values_vl
205: WHERE upper(lookup_type) = 'GHG_LOCATION'
206: AND TRUNC(SYSDATE) BETWEEN start_date_active AND NVL(end_date_active,GHG_utilities_pkg.end_date)
207: AND lookup_code = p_emission_location;
208:

Line 329: FROM fnd_lookup_values_vl

325: RAISE raise_error;
326: ELSE
327: SELECT count(*)
328: INTO v_check
329: FROM fnd_lookup_values_vl
330: WHERE upper(lookup_type) = 'GHG_TXN_TYPE'
331: AND TRUNC(SYSDATE) BETWEEN start_date_active AND NVL(end_date_active,GHG_utilities_pkg.end_date)
332: AND lookup_code = p_batch_type;
333:

Line 505: FROM fnd_lookup_values_vl

501: RAISE raise_error;
502: ELSE
503: SELECT count(*)
504: INTO v_check
505: FROM fnd_lookup_values_vl
506: WHERE upper(lookup_type) = 'GHG_EMISSION_SCOPE'
507: AND TRUNC(SYSDATE) BETWEEN start_date_active AND NVL(end_date_active,GHG_utilities_pkg.end_date)
508: AND lookup_code = nvl(p_emission_scope,v_emission_scope);
509:

Line 588: FROM fnd_lookup_values_vl

584: RAISE raise_error;
585: ELSE
586: SELECT count(*)
587: INTO v_check
588: FROM fnd_lookup_values_vl
589: WHERE upper(lookup_type) = 'GHG_LOCATION'
590: AND TRUNC(SYSDATE) BETWEEN start_date_active AND NVL(end_date_active,GHG_utilities_pkg.end_date)
591: AND lookup_code = v_emission_location;
592: --AND lookup_code = nvl(p_emission_location,v_emission_location);

Line 1071: 'FROM FND_LOOKUP_VALUES' ||

1067: 'SELECT ' || p_org_id || ', ' ||
1068: 'LOOKUP_CODE, ' ||
1069: 'LOOKUP_CODE, ' ||
1070: 'DESCRIPTION ' ||
1071: 'FROM FND_LOOKUP_VALUES' ||
1072: ' WHERE LOOKUP_TYPE = ''GHG_EMISSION_SCOPE''' || ' AND LANGUAGE='||concat(''''||v_language||'','''');
1073:
1074: execute immediate v_stmt;
1075:

Line 1364: , fnd_lookup_values anz

1360: fac.longitude,
1361: location_code
1362: from GHG_ORGANIZATIONS_ALL fac
1363: , GHG_ORG_SIC_MAPPINGS_ALL sic
1364: , fnd_lookup_values anz
1365: , fnd_lookup_values div
1366: , hr_locations hr
1367: , fnd_territories_vl tr
1368: where fac.ghg_organization_id = sic.ghg_organization_id(+)

Line 1365: , fnd_lookup_values div

1361: location_code
1362: from GHG_ORGANIZATIONS_ALL fac
1363: , GHG_ORG_SIC_MAPPINGS_ALL sic
1364: , fnd_lookup_values anz
1365: , fnd_lookup_values div
1366: , hr_locations hr
1367: , fnd_territories_vl tr
1368: where fac.ghg_organization_id = sic.ghg_organization_id(+)
1369: and anz.lookup_type(+) = 'GHG_SIC_CODES'

Line 1561: ', (select meaning from fnd_lookup_values_vl lv where lookup_type in (''GHG_TXN_TYPE'', ''GHG_INTERNAL_TXN_TYPE'') and tr.txn_type_lookup_code = lv.lookup_code) document_type ' ||

1557: 'ENTERED_USAGE_UOM ' ||
1558: ') ' ||
1559: 'SELECT tr.org_id SOURCE_APPLICATION_CODE ' ||
1560: ', tr.transaction_id transaction_id ' ||
1561: ', (select meaning from fnd_lookup_values_vl lv where lookup_type in (''GHG_TXN_TYPE'', ''GHG_INTERNAL_TXN_TYPE'') and tr.txn_type_lookup_code = lv.lookup_code) document_type ' ||
1562: ', decode(tr.txn_type_lookup_code, ''INT_INVOICE'', ap.invoice_num, tr.transaction_id) document_identifier1 ' ||
1563: ', rp.actual_date transaction_date ' ||
1564: ', nvl(ap.invoice_amount,0)/((tr.transaction_date_to-tr.transaction_date_from)+1) transaction_value ' ||
1565: ', ap.invoice_currency_code transaction_currency_code ' ||

Line 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 ' ||

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 ' ||
1574: ', (nvl(tr.emission_quantity,0) /((tr.transaction_date_to-tr.transaction_date_from)+1))* '||fnd_number.NUMBER_TO_CANONICAL(v_final_conv_rate) || 'co2_e_quantity ' ||
1575: ', ''' || v_uom || ''' co2_e_uom ' ||

Line 1833: '(select meaning from fnd_lookup_values lv where lv.language='||concat(''''||v_language||'','''') || ' and lv.lookup_type = ''GHG_INTERESTED_TYPES'' and a.operational_control = lv.lookup_code), ' ||

1829: 'a.ghg_organization_id, ' ||
1830: 'a.start_date, ' ||
1831: 'a.end_date, ' ||
1832: 'a.operational_control, ' ||
1833: '(select meaning from fnd_lookup_values lv where lv.language='||concat(''''||v_language||'','''') || ' and lv.lookup_type = ''GHG_INTERESTED_TYPES'' and a.operational_control = lv.lookup_code), ' ||
1834: 'a.equity_share , ' ||
1835: 'b.ORGANIZATION_id, ' ||
1836: 'a.CONTROLLING_ORGANIZATION_ID, ' ||
1837: 'b.ceo_name, ' ||

Line 1898: '(select meaning from fnd_lookup_values lv where lv.language='||concat(''''||v_language||'','''') || ' and lv.lookup_type = ''GHG_INTERESTED_TYPES'' and a.operational_control = lv.lookup_code), ' ||

1894: 'a.ghg_organization_id, ' ||
1895: 'a.start_date, ' ||
1896: 'a.end_date, ' ||
1897: 'a.operational_control, ' ||
1898: '(select meaning from fnd_lookup_values lv where lv.language='||concat(''''||v_language||'','''') || ' and lv.lookup_type = ''GHG_INTERESTED_TYPES'' and a.operational_control = lv.lookup_code), ' ||
1899: 'a.equity_share , ' ||
1900: 'b.ORGANIZATION_id, ' ||
1901: 'a.CONTROLLING_ORGANIZATION_ID, ' ||
1902: 'b.ceo_name, ' ||

Line 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 ' ||

1963: '0 denominator_value, ' ||
1964: 'kpd.den_function denominator_action, ' ||
1965: 'initcap(kpd.num_type) numerator_value_type, ' ||
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 ' ||