APPS.HZ_IMP_DQM_STAGE dependencies on HZ_IMP_ADDRESSES_INT

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 933: p_table_name := 'HZ_IMP_ADDRESSES_INT';

929: BEGIN
930: IF ((p_entity_name = 'PARTY') OR (p_entity_name = 'HZ_STAGED_PARTIES')) THEN
931: p_table_name := 'HZ_IMP_PARTIES_INT';
932: ELSIF ((p_entity_name = 'PARTY_SITES') OR (p_entity_name = 'HZ_STAGED_PARTY_SITES')) THEN
933: p_table_name := 'HZ_IMP_ADDRESSES_INT';
934: ELSIF ((p_entity_name = 'CONTACTS') OR (p_entity_name = 'HZ_STAGED_CONTACTS')) THEN
935: p_table_name := 'HZ_IMP_CONTACTS_INT';
936: ELSIF ((p_entity_name = 'CONTACT_POINTS') OR (p_entity_name = 'HZ_STAGED_CONTACT_POINTS')) THEN
937: p_table_name := 'HZ_IMP_CONTACTPTS_INT';

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'' ');

Line 2455: l(' from hz_imp_addresses_int a ');

2451: l_sel_str := '';
2452: /* select a.party_orig_system, a.party_orig_system_reference,
2453: a.site_orig_system, a.site_orig_system_reference,
2454: a.address1, a.postal_code */
2455: l(' from hz_imp_addresses_int a ');
2456: l(' where a.batch_id = p_batch_id ');
2457: l(' and a.party_orig_system_reference >= p_from_osr ');
2458: l(' and a.party_orig_system_reference <= p_to_osr ');
2459: l(' and a.party_orig_system = l_os; ');

Line 3630: where table_name = 'HZ_IMP_ADDRESSES_INT'

3626:
3627:
3628: CURSOR c1 is select 'Y'
3629: from sys.dba_tab_columns
3630: where table_name = 'HZ_IMP_ADDRESSES_INT'
3631: and column_name = l_attribute_name and owner = l_owner;
3632: BEGIN
3633: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3634: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');

Line 3774: EXECUTE IMMEDIATE 'select '||attr_name||' from HZ_IMP_ADDRESSES_INT where rownum=1';

3770: ELSIF entity = 'PARTY_SITES' or entity = 'HZ_STAGED_PARTY_SITES' THEN
3771: IF attr_name IN ('ADDRESS') THEN
3772: RETURN 'Y';
3773: END IF;
3774: EXECUTE IMMEDIATE 'select '||attr_name||' from HZ_IMP_ADDRESSES_INT where rownum=1';
3775: ELSIF entity = 'CONTACTS' or entity = 'HZ_STAGED_CONTACTS' THEN
3776: IF attr_name IN ('CONTACT_NAME') THEN
3777: RETURN 'Y';
3778: END IF;