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.HZ_IMP_LOAD_ADDRESSES_PKG dependencies on FND_GLOBAL

Line 978: fnd_global.lookup_security_group(''HZ_CREATED_BY_MODULES'', 222)

974: and createdby_l.lookup_type (+) = ''HZ_CREATED_BY_MODULES''
975: and createdby_l.language (+) = userenv(''LANG'')
976: and createdby_l.view_application_id (+) = 222
977: and createdby_l.security_group_id (+) =
978: fnd_global.lookup_security_group(''HZ_CREATED_BY_MODULES'', 222)
979: AND timezone.timezone_code (+) = site_int.timezone_code';
980:
981: l_where_enabled_lookup_sql varchar2(4000) :=
982: 'AND ( createdby_l.ENABLED_FLAG(+) = ''Y'' AND

Line 1524: fnd_global.lookup_security_group(''HZ_CREATED_BY_MODULES'', 222)

1520: AND createdby_l.lookup_type (+) = ''HZ_CREATED_BY_MODULES''
1521: AND createdby_l.language (+) = userenv(''LANG'')
1522: AND createdby_l.view_application_id (+) = 222
1523: AND createdby_l.security_group_id (+) =
1524: fnd_global.lookup_security_group(''HZ_CREATED_BY_MODULES'', 222)
1525: ';
1526:
1527: l_sql_query_w_prf VARCHAR2(20000) :=
1528: 'SELECT --hz_loc_prf.validation_status_code,

Line 1752: fnd_global.lookup_security_group(''HZ_CREATED_BY_MODULES'', 222)

1748: AND createdby_l.lookup_type (+) = ''HZ_CREATED_BY_MODULES''
1749: AND createdby_l.language (+) = userenv(''LANG'')
1750: AND createdby_l.view_application_id (+) = 222
1751: AND createdby_l.security_group_id (+) =
1752: fnd_global.lookup_security_group(''HZ_CREATED_BY_MODULES'', 222)
1753: ';
1754:
1755: l_where_enabled_lookup_sql varchar2(4000) :=
1756: 'AND ( createdby_l.ENABLED_FLAG(+) = ''Y'' AND

Line 1935: p_user_name => fnd_global.user_name,

1931: hz_dss_util_pub.test_instance(
1932: p_operation_code => 'UPDATE',
1933: p_db_object_name => 'HZ_PARTY_SITES',
1934: p_instance_pk1_value => l_site_id(i),
1935: p_user_name => fnd_global.user_name,
1936: x_return_status => dss_return_status,
1937: x_msg_count => dss_msg_count,
1938: x_msg_data => dss_msg_data);
1939: END LOOP;

Line 3242: FND_GLOBAL.Login_ID PROGRAM_LOGIN_ID ,

3238: USING
3239: (SELECT 'THIRD_PARTY_SITE' PARTY_TYPE_CODE,
3240: ps.party_site_id PARTY_ID,
3241: loc.country COUNTRY_CODE,--4742586
3242: FND_GLOBAL.Login_ID PROGRAM_LOGIN_ID ,
3243: NULL TAX_REFERENCE,
3244: SYSDATE CREATION_DATE,
3245: FND_GLOBAL.User_ID CREATED_BY,
3246: SYSDATE LAST_UPDATE_DATE,

Line 3245: FND_GLOBAL.User_ID CREATED_BY,

3241: loc.country COUNTRY_CODE,--4742586
3242: FND_GLOBAL.Login_ID PROGRAM_LOGIN_ID ,
3243: NULL TAX_REFERENCE,
3244: SYSDATE CREATION_DATE,
3245: FND_GLOBAL.User_ID CREATED_BY,
3246: SYSDATE LAST_UPDATE_DATE,
3247: FND_GLOBAL.User_ID LAST_UPDATED_BY,
3248: FND_GLOBAL.Login_ID LAST_UPDATE_LOGIN
3249: FROM HZ_PARTY_SITES ps, HZ_IMP_ADDRESSES_SG pssg,HZ_LOCATIONS loc, --4742586

Line 3247: FND_GLOBAL.User_ID LAST_UPDATED_BY,

3243: NULL TAX_REFERENCE,
3244: SYSDATE CREATION_DATE,
3245: FND_GLOBAL.User_ID CREATED_BY,
3246: SYSDATE LAST_UPDATE_DATE,
3247: FND_GLOBAL.User_ID LAST_UPDATED_BY,
3248: FND_GLOBAL.Login_ID LAST_UPDATE_LOGIN
3249: FROM HZ_PARTY_SITES ps, HZ_IMP_ADDRESSES_SG pssg,HZ_LOCATIONS loc, --4742586
3250: HZ_IMP_ADDRESSES_INT psint
3251: WHERE loc.request_id = p_request_id --Bug No.4956874.SQLID:14455142

Line 3248: FND_GLOBAL.Login_ID LAST_UPDATE_LOGIN

3244: SYSDATE CREATION_DATE,
3245: FND_GLOBAL.User_ID CREATED_BY,
3246: SYSDATE LAST_UPDATE_DATE,
3247: FND_GLOBAL.User_ID LAST_UPDATED_BY,
3248: FND_GLOBAL.Login_ID LAST_UPDATE_LOGIN
3249: FROM HZ_PARTY_SITES ps, HZ_IMP_ADDRESSES_SG pssg,HZ_LOCATIONS loc, --4742586
3250: HZ_IMP_ADDRESSES_INT psint
3251: WHERE loc.request_id = p_request_id --Bug No.4956874.SQLID:14455142
3252: AND ps.party_site_id = pssg.party_site_id -- Bug 5210879.