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_DQM_STAGE dependencies on HZ_IMP_ADDRESSES_SG

Line 238: from hz_imp_addresses_int a, HZ_IMP_ADDRESSES_SG b

234: -- - Update IDs on PARTY SITES
235: log( ' Update party_sites since address validation was not run');
236:
237: update HZ_SRCH_PSITES c set party_site_id = ( select b.party_site_id
238: from hz_imp_addresses_int a, HZ_IMP_ADDRESSES_SG b
239: where a.rowid = b.int_row_id
240: and c.int_row_id = a.rowid
241: and a.batch_id = p_batch_id
242: and a.batch_id = c.batch_id

Line 245: from hz_imp_addresses_int a, HZ_IMP_ADDRESSES_SG b

241: and a.batch_id = p_batch_id
242: and a.batch_id = c.batch_id
243: and b.action_flag = 'I' ),
244: party_id = ( select b.party_id
245: from hz_imp_addresses_int a, HZ_IMP_ADDRESSES_SG b
246: where a.rowid = b.int_row_id
247: and c.int_row_id = a.rowid
248: and a.batch_id = p_batch_id
249: and a.batch_id = c.batch_id

Line 518: from HZ_IMP_ADDRESSES_SG b

514: IF (p_et_name = 'PSITES') THEN
515: delete from hz_srch_psites a
516: where a.party_os || a.party_osr in (
517: select a.party_os || a.party_osr
518: from HZ_IMP_ADDRESSES_SG b
519: where a.party_os = b.party_orig_system
520: and a.party_osr = b.party_orig_system_reference
521: and b.action_flag = 'U'
522: and a.batch_id = p_batch_id);

Line 2276: l(' from hz_imp_addresses_int a, hz_imp_addresses_sg b ');

2272: select a.party_orig_system, a.party_orig_system_reference,
2273: a.site_orig_system, a.site_orig_system_reference,
2274: b.party_id, b.party_site_id, a.address1, a.postal_code
2275: */
2276: l(' from hz_imp_addresses_int a, hz_imp_addresses_sg b ');
2277: l(' where a.batch_id = p_batch_id ');
2278: l(' and b.action_flag = ''I'' ');
2279: l(' and b.int_row_id = a.rowid ');
2280: --l(' and nvl(a.accept_standardized_flag, ''N'') <> ''Y'' ');

Line 2296: l(' from hz_imp_addresses_int a, hz_imp_addresses_sg b ');

2292: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2293: fnd_log.string(fnd_log.LEVEL_PROCEDURE,G_PKG_NAME||l_procedure_name,l_sel_str);
2294: END IF;
2295: l_sel_str := '';
2296: l(' from hz_imp_addresses_int a, hz_imp_addresses_sg b ');
2297: l(' where a.batch_id = p_batch_id ');
2298: l(' and b.action_flag = ''I'' ');
2299: l(' and b.int_row_id = a.rowid ');
2300: l(' and a.accept_standardized_flag = ''Y'' ');