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_WRAPPER dependencies on HZ_IMP_CONTACTS_SG

Line 178: from hz_imp_contacts_sg s

174: nvl(start_date, sysdate) sd, nvl(end_date,
175: to_date('31-12-4712 00:00:01', 'DD-MM-YYYY HH24:MI:SS'))
176: ed, relationship_code rc, relationship_type rt,
177: 'HZ_IMP_CONTACTS_INT' table_name
178: from hz_imp_contacts_sg s
179: where batch_id = p_batch_id
180: and batch_mode_flag = p_batch_mode_flag
181: and action_flag = 'I'
182: ) r

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

657: execute immediate 'ALTER TABLE ' || l_schema || '.HZ_IMP_CLASSIFICS_SG TRUNCATE PARTITION batchpar DROP STORAGE';
658: execute immediate 'ALTER TABLE ' || l_schema || '.HZ_IMP_FINREPORTS_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

Line 690: DELETE HZ_IMP_CONTACTS_SG

686: AND batch_mode_flag = P_BATCH_MODE_FLAG;
687: DELETE HZ_IMP_RELSHIPS_SG
688: WHERE batch_id = P_BATCH_ID
689: AND batch_mode_flag = P_BATCH_MODE_FLAG;
690: DELETE HZ_IMP_CONTACTS_SG
691: WHERE batch_id = P_BATCH_ID
692: AND batch_mode_flag = P_BATCH_MODE_FLAG;
693: DELETE HZ_IMP_CONTACTROLES_SG
694: WHERE batch_id = P_BATCH_ID

Line 4055: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTS_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);
4056: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CREDITRTNGS_SG', percent=>5, degree=>4);
4057: fnd_stats.gather_table_stats('AR', 'HZ_IMP_FINNUMBERS_SG', percent=>5, degree=>4);
4058: fnd_stats.gather_table_stats('AR', 'HZ_IMP_FINREPORTS_SG', percent=>5, degree=>4);
4059: fnd_stats.gather_table_stats('AR', 'HZ_IMP_RELSHIPS_SG', percent=>5, degree=>4);

Line 4724: FROM HZ_IMP_CONTACTS_SG

4720: AND batch_mode_flag = p_batch_mode_flag
4721: AND rownum = 1)
4722: OR EXISTS (
4723: SELECT 'Y'
4724: FROM HZ_IMP_CONTACTS_SG
4725: WHERE batch_id = p_batch_id
4726: AND batch_mode_flag = p_batch_mode_flag
4727: AND rownum = 1)
4728: OR EXISTS (

Line 4789: FROM HZ_IMP_CONTACTS_SG

4785: AND batch_mode_flag = p_batch_mode_flag
4786: AND rownum = 1)
4787: OR EXISTS (
4788: SELECT 'Y'
4789: FROM HZ_IMP_CONTACTS_SG
4790: WHERE batch_id = p_batch_id
4791: AND batch_mode_flag = p_batch_mode_flag
4792: AND rownum = 1)
4793: OR EXISTS (