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_ORGANIZATIONS_ALL

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