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 HZ_IMP_ADDRESSES_SG

Line 952: HZ_IMP_ADDRESSES_SG site_sg,

948: site_int.attribute15, site_int.attribute16, site_int.attribute17, site_int.attribute18, site_int.attribute19,
949: site_int.attribute20, :5, :2
950: ), ''T'') flex_val_error
951: FROM HZ_IMP_ADDRESSES_INT site_int,
952: HZ_IMP_ADDRESSES_SG site_sg,
953: FND_TERRITORIES fnd_terr,
954: FND_TERRITORIES fnd_terr2,
955: (select language_code
956: from FND_LANGUAGES

Line 1047: hz_imp_addresses_sg addr_sg,

1043: (
1044: select addr_sg.party_id,
1045: hz_ps.party_site_id
1046: from HZ_IMP_TMP_ERRORS err_table,
1047: hz_imp_addresses_sg addr_sg,
1048: hz_party_sites hz_ps
1049: where err_table.request_id = :request_id
1050: and interface_table_name = ''HZ_IMP_ADDRESSES_INT''
1051: and addr_sg.batch_id = :batch_id

Line 1136: from hz_imp_addresses_sg addr_sg

1132: IF g_pst_is_datasource_selected = 'Y' THEN
1133: */
1134: OPEN de_norm_cursor FOR
1135: 'select addr_sg.party_id, addr_sg.party_site_id
1136: from hz_imp_addresses_sg addr_sg
1137: where addr_sg.batch_id = :batch_id
1138: and addr_sg.batch_mode_flag = :batch_mode_flag
1139: and addr_sg.party_orig_system = :orig_system
1140: and addr_sg.party_orig_system_reference

Line 1280: from hz_imp_addresses_sg fr_sg

1276: dup_val_exp_val,
1277: other_exp_val, 'Y',
1278: 'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y',
1279: 'Y'
1280: from hz_imp_addresses_sg fr_sg
1281: where fr_sg.action_flag = 'I'
1282: and fr_sg.batch_id = P_DML_RECORD.BATCH_ID
1283: and fr_sg.party_orig_system = P_DML_RECORD.OS
1284: and fr_sg.party_orig_system_reference

Line 1474: HZ_IMP_ADDRESSES_SG site_sg,

1470: ),
1471: ''Y'') createdby_error
1472:
1473: FROM HZ_IMP_ADDRESSES_INT site_int,
1474: HZ_IMP_ADDRESSES_SG site_sg,
1475: FND_TERRITORIES fnd_terr,
1476: FND_TERRITORIES fnd_terr2,
1477: ( select language_code
1478: from FND_LANGUAGES

Line 1705: HZ_IMP_ADDRESSES_SG site_sg,

1701: ),
1702: ''Y'') createdby_error
1703:
1704: FROM HZ_IMP_ADDRESSES_INT site_int,
1705: HZ_IMP_ADDRESSES_SG site_sg,
1706: FND_TERRITORIES fnd_terr,
1707: FND_TERRITORIES fnd_terr2,
1708: ( select language_code
1709: from FND_LANGUAGES

Line 3253: FROM HZ_PARTY_SITES ps, HZ_IMP_ADDRESSES_SG pssg,HZ_LOCATIONS loc, --4742586

3249: FND_GLOBAL.User_ID CREATED_BY,
3250: SYSDATE LAST_UPDATE_DATE,
3251: FND_GLOBAL.User_ID LAST_UPDATED_BY,
3252: FND_GLOBAL.Login_ID LAST_UPDATE_LOGIN
3253: FROM HZ_PARTY_SITES ps, HZ_IMP_ADDRESSES_SG pssg,HZ_LOCATIONS loc, --4742586
3254: HZ_IMP_ADDRESSES_INT psint
3255: WHERE loc.request_id = p_request_id --Bug No.4956874.SQLID:14455142
3256: AND ps.party_site_id = pssg.party_site_id -- Bug 5210879.
3257: AND loc.location_id = ps.location_id --4742586