APPS.HZ_IMP_LOAD_WRAPPER dependencies on HZ_IMP_ADDRESSUSES_SG

Line 205: from hz_imp_addressuses_sg s

201: select int_row_id, hz_imp_errors_s.NextVal from (
202: select /*+ parallel(s) */ party_site_use_id suid, party_site_id sid,
203: site_use_type sut, int_row_id, lead(party_site_id, 1) over(
204: partition by site_use_type order by primary_flag desc) n_sid
205: from hz_imp_addressuses_sg s
206: where s.batch_id = p_batch_id
207: and s.batch_mode_flag = p_batch_mode_flag
208: and s.action_flag = 'I'
209: ) r

Line 663: execute immediate 'ALTER TABLE ' || l_schema || '.HZ_IMP_ADDRESSUSES_SG TRUNCATE PARTITION batchpar DROP STORAGE';

659: execute immediate 'ALTER TABLE ' || l_schema || '.HZ_IMP_FINNUMBERS_SG TRUNCATE PARTITION batchpar DROP STORAGE';
660: execute immediate 'ALTER TABLE ' || l_schema || '.HZ_IMP_RELSHIPS_SG TRUNCATE PARTITION batchpar DROP STORAGE';
661: execute immediate 'ALTER TABLE ' || l_schema || '.HZ_IMP_CONTACTS_SG TRUNCATE PARTITION batchpar DROP STORAGE';
662: execute immediate 'ALTER TABLE ' || l_schema || '.HZ_IMP_CONTACTROLES_SG TRUNCATE PARTITION batchpar DROP STORAGE';
663: execute immediate 'ALTER TABLE ' || l_schema || '.HZ_IMP_ADDRESSUSES_SG TRUNCATE PARTITION batchpar DROP STORAGE';
664:
665: ELSE
666: DELETE HZ_IMP_PARTIES_SG
667: WHERE batch_id = P_BATCH_ID

Line 696: DELETE HZ_IMP_ADDRESSUSES_SG

692: AND batch_mode_flag = P_BATCH_MODE_FLAG;
693: DELETE HZ_IMP_CONTACTROLES_SG
694: WHERE batch_id = P_BATCH_ID
695: AND batch_mode_flag = P_BATCH_MODE_FLAG;
696: DELETE HZ_IMP_ADDRESSUSES_SG
697: WHERE batch_id = P_BATCH_ID
698: AND batch_mode_flag = P_BATCH_MODE_FLAG;
699:
700: END IF;

Line 4051: fnd_stats.gather_table_stats('AR', 'HZ_IMP_ADDRESSUSES_SG', percent=>5, degree=>4);

4047: -- Analyze staging table after matching
4048: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Analyze other entity staging tables ' ||
4049: to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
4050: fnd_stats.gather_table_stats('AR', 'HZ_IMP_ADDRESSES_SG', percent=>5, degree=>4);
4051: fnd_stats.gather_table_stats('AR', 'HZ_IMP_ADDRESSUSES_SG', percent=>5, degree=>4);
4052: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CLASSIFICS_SG', percent=>5, degree=>4);
4053: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTPTS_SG', percent=>5, degree=>4);
4054: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTROLES_SG', percent=>5, degree=>4);
4055: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTS_SG', percent=>5, degree=>4);

Line 4730: FROM HZ_IMP_ADDRESSUSES_SG

4726: AND batch_mode_flag = p_batch_mode_flag
4727: AND rownum = 1)
4728: OR EXISTS (
4729: SELECT 'Y'
4730: FROM HZ_IMP_ADDRESSUSES_SG
4731: WHERE batch_id = p_batch_id
4732: AND batch_mode_flag = p_batch_mode_flag
4733: AND rownum = 1);
4734:

Line 4795: FROM HZ_IMP_ADDRESSUSES_SG

4791: AND batch_mode_flag = p_batch_mode_flag
4792: AND rownum = 1)
4793: OR EXISTS (
4794: SELECT 'Y'
4795: FROM HZ_IMP_ADDRESSUSES_SG
4796: WHERE batch_id = p_batch_id
4797: AND batch_mode_flag = p_batch_mode_flag
4798: AND rownum = 1);
4799: