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 GHG_ORGANIZATIONS

Line 527: FROM GHG_ORGANIZATIONS_V

523: ELSE
524: BEGIN
525: SELECT ghg_organization_id
526: INTO v_facility_id
527: FROM GHG_ORGANIZATIONS_V
528: WHERE ghg_organization_code = p_facility
529: AND allow_transactions = 'Y';
530:
531: EXCEPTION

Line 540: FROM GHG_ORGANIZATIONS_V

536:
537: BEGIN
538: SELECT ghg_organization_id
539: INTO v_facility_id
540: FROM GHG_ORGANIZATIONS_V
541: WHERE ghg_organization_code = p_facility
542: AND p_emission_from_date BETWEEN start_date AND nvl(end_date, GHG_utilities_pkg.end_date)
543: AND p_emission_to_date BETWEEN start_date AND nvl(end_date, GHG_utilities_pkg.end_date)
544: AND allow_transactions = 'Y';

Line 570: from GHG_organizations fac

566: WHERE fnd.APPLICATION_ID =800
567: AND fnd.DESCRIPTIVE_FLEXFIELD_NAME='Address Location'
568: AND fnd.DESCRIPTIVE_FLEX_CONTEXT_CODE = hr.style
569: AND exists (select 1
570: from GHG_organizations fac
571: where fac.ghg_organization_id = v_facility_id
572: and fac.location_id = hr.location_id)
573: AND upper(end_user_column_name) = fnd_profile.value('GHG_FACTOR_BREAK_REGION');
574: EXCEPTION

Line 1019: clear_table('GHG_ORGANIZATIONS_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);
1019: clear_table('GHG_ORGANIZATIONS_D', v_dblink);
1020:
1021:
1022: clear_table('GHG_TRANSACTIONS_D', v_dblink);
1023: clear_table('GHG_TRANSACTION_DETAILS_F', v_dblink);

Line 1296: 'where not exists ( select 1 from GHG_ORGANIZATIONS_ALL fac ' ||

1292:
1293: write_to_log('Deleting from GHG_ORG_HIERARCHY_STRUCTURES_D');
1294: v_stmt :=
1295: 'delete from GHG_ORG_HIERARCHY_STRUCTURES_D@' || v_dblink || ' str ' ||
1296: 'where not exists ( select 1 from GHG_ORGANIZATIONS_ALL fac ' ||
1297: 'where allow_transactions = ''Y''' ||
1298: ' and str.ORGANIZATION_id = fac.ghg_organization_id)';
1299:
1300: EXECUTE IMMEDIATE v_stmt;

Line 1308: write_to_log('Inserting into GHG_ORGANIZATIONS_D_TMP');

1304: write_to_log(substr(SQLERRM, 1, 200));
1305: end;
1306:
1307:
1308: write_to_log('Inserting into GHG_ORGANIZATIONS_D_TMP');
1309: INSERT INTO GHG_ORGANIZATIONS_D_TMP
1310: ( SOURCE_APPLICATION_CODE,
1311: ORGANIZATION_ID,
1312: ORGANIZATION_EXTERNAL_ID,

Line 1309: INSERT INTO GHG_ORGANIZATIONS_D_TMP

1305: end;
1306:
1307:
1308: write_to_log('Inserting into GHG_ORGANIZATIONS_D_TMP');
1309: INSERT INTO GHG_ORGANIZATIONS_D_TMP
1310: ( SOURCE_APPLICATION_CODE,
1311: ORGANIZATION_ID,
1312: ORGANIZATION_EXTERNAL_ID,
1313: ORGANIZATION_CODE,

Line 1362: from GHG_ORGANIZATIONS_ALL fac

1358: postal_code,
1359: fac.latitude,
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

Line 1382: write_to_log('Inserting into GHG_ORGANIZATIONS_D');

1378:
1379:
1380:
1381:
1382: write_to_log('Inserting into GHG_ORGANIZATIONS_D');
1383: v_stmt :=
1384: 'INSERT INTO GHG_ORGANIZATIONS_D@' || v_dblink ||
1385: '( SOURCE_APPLICATION_CODE, ' ||
1386: 'ORGANIZATION_ID, ' ||

Line 1384: 'INSERT INTO GHG_ORGANIZATIONS_D@' || v_dblink ||

1380:
1381:
1382: write_to_log('Inserting into GHG_ORGANIZATIONS_D');
1383: v_stmt :=
1384: 'INSERT INTO GHG_ORGANIZATIONS_D@' || v_dblink ||
1385: '( SOURCE_APPLICATION_CODE, ' ||
1386: 'ORGANIZATION_ID, ' ||
1387: 'ORGANIZATION_EXTERNAL_ID, ' ||
1388: 'ORGANIZATION_CODE, ' ||

Line 1437: 'from GHG_ORGANIZATIONS_D_TMP WHERE SOURCE_APPLICATION_CODE='|| p_org_id ||'';

1433: 'ADDRESS_POSTCODE, ' ||
1434: 'ADDRESS_LATITUDE, ' ||
1435: 'address_longitude, ' ||
1436: 'ADDRESS_LOCATION ' ||
1437: 'from GHG_ORGANIZATIONS_D_TMP WHERE SOURCE_APPLICATION_CODE='|| p_org_id ||'';
1438:
1439:
1440: EXECUTE IMMEDIATE v_stmt;
1441:

Line 1480: 'from GHG_ORGANIZATIONS_D_TMP org ' ||

1476: 'ORGANIZATION_id, ' ||
1477: 'ORGANIZATION_id, ' ||
1478: 'ORGANIZATION_id, ' ||
1479: '''N'' ' ||
1480: 'from GHG_ORGANIZATIONS_D_TMP org ' ||
1481: 'where not exists (select 1 ' ||
1482: 'from GHG_ORG_HIERARCHY_STRUCTURES_D@' || v_dblink || ' st ' ||
1483: 'where org.ORGANIZATION_id = st.ORGANIZATION_id) AND SOURCE_APPLICATION_CODE='|| p_org_id ||'';
1484:

Line 1580: ', (select address_state from GHG_ORGANIZATIONS_D_TMP org where org.ORGANIZATION_id = tr.ghg_organization_id) location_state ' ||

1576: ', tr.ghg_asset_id asset_id ' ||
1577: ', tr.vendor_id supplier_id ' ||
1578: ', tr.inventory_item_id item_id ' ||
1579: ', ''A'' actual_or_estimate ' ||
1580: ', (select address_state from GHG_ORGANIZATIONS_D_TMP org where org.ORGANIZATION_id = tr.ghg_organization_id) location_state ' ||
1581: ', (select address_country from GHG_ORGANIZATIONS_D_TMP org where org.ORGANIZATION_id = tr.ghg_organization_id) location_county ' ||
1582: ', tr.ghg_organization_id ORGANIZATION_id ' ||
1583: ', tr.measurement_criteria measurement_criteria_code ' ||
1584: ', tr.measurement_criteria measurement_criteria_desc ' ||

Line 1581: ', (select address_country from GHG_ORGANIZATIONS_D_TMP org where org.ORGANIZATION_id = tr.ghg_organization_id) location_county ' ||

1577: ', tr.vendor_id supplier_id ' ||
1578: ', tr.inventory_item_id item_id ' ||
1579: ', ''A'' actual_or_estimate ' ||
1580: ', (select address_state from GHG_ORGANIZATIONS_D_TMP org where org.ORGANIZATION_id = tr.ghg_organization_id) location_state ' ||
1581: ', (select address_country from GHG_ORGANIZATIONS_D_TMP org where org.ORGANIZATION_id = tr.ghg_organization_id) location_county ' ||
1582: ', tr.ghg_organization_id ORGANIZATION_id ' ||
1583: ', tr.measurement_criteria measurement_criteria_code ' ||
1584: ', tr.measurement_criteria measurement_criteria_desc ' ||
1585: ', nvl(tr.usage_quantity,0) ' ||

Line 1849: ', GHG_ORGANIZATIONS_D_TMP b ' ||

1845: 'b.address_county, ' ||
1846: 'b.address_country, ' ||
1847: 'b.ADDRESS_POSTCODE ' ||
1848: 'from GHG_INTERESTED_PARTIES_ALL a ' ||
1849: ', GHG_ORGANIZATIONS_D_TMP b ' ||
1850: 'where org_id = source_application_code ' ||
1851: 'and a.CONTROLLING_ORGANIZATION_ID = b.ORGANIZATION_code ' ||
1852: ' and a.operational_control <> ''OPC''';
1853: IF p_org_id IS NOT NULL THEN

Line 1914: ', GHG_ORGANIZATIONS_D_TMP b ' ||

1910: 'b.address_county, ' ||
1911: 'b.address_country, ' ||
1912: 'b.ADDRESS_POSTCODE ' ||
1913: 'from GHG_INTERESTED_PARTIES_ALL a ' ||
1914: ', GHG_ORGANIZATIONS_D_TMP b ' ||
1915: 'where org_id = source_application_code ' ||
1916: 'and a.CONTROLLING_ORGANIZATION_ID = b.ORGANIZATION_code ' ||
1917: 'and a.operational_control = ''OPC''';
1918: IF p_org_id IS NOT NULL THEN