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_CLASSIFICS_SG

Line 228: from hz_imp_classifics_sg s,

224: lead(s.start_date_active, 1) over(partition by s.party_id,
225: s.class_category order by s.start_date_active,
226: s.end_date_active nulls last, s.primary_flag desc) lsd2,
227: c_cat.allow_multi_assign_flag
228: from hz_imp_classifics_sg s,
229: hz_class_categories c_cat,
230: hz_imp_classifics_int c_int
231: where s.batch_id = p_batch_id
232: and s.batch_mode_flag = p_batch_mode_flag

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

653: execute immediate 'ALTER TABLE ' || l_schema || '.HZ_IMP_PARTIES_SG TRUNCATE PARTITION batchpar DROP STORAGE';
654: execute immediate 'ALTER TABLE ' || l_schema || '.HZ_IMP_ADDRESSES_SG TRUNCATE PARTITION batchpar DROP STORAGE';
655: execute immediate 'ALTER TABLE ' || l_schema || '.HZ_IMP_CONTACTPTS_SG TRUNCATE PARTITION batchpar DROP STORAGE';
656: execute immediate 'ALTER TABLE ' || l_schema || '.HZ_IMP_CREDITRTNGS_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';

Line 678: DELETE HZ_IMP_CLASSIFICS_SG

674: AND batch_mode_flag = P_BATCH_MODE_FLAG;
675: DELETE HZ_IMP_CREDITRTNGS_SG
676: WHERE batch_id = P_BATCH_ID
677: AND batch_mode_flag = P_BATCH_MODE_FLAG;
678: DELETE HZ_IMP_CLASSIFICS_SG
679: WHERE batch_id = P_BATCH_ID
680: AND batch_mode_flag = P_BATCH_MODE_FLAG;
681: DELETE HZ_IMP_FINREPORTS_SG
682: WHERE batch_id = P_BATCH_ID

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

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);
4056: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CREDITRTNGS_SG', percent=>5, degree=>4);

Line 4706: FROM HZ_IMP_CLASSIFICS_SG

4702: AND batch_mode_flag = p_batch_mode_flag
4703: AND rownum = 1)
4704: OR EXISTS (
4705: SELECT 'Y'
4706: FROM HZ_IMP_CLASSIFICS_SG
4707: WHERE batch_id = p_batch_id
4708: AND batch_mode_flag = p_batch_mode_flag
4709: AND rownum = 1)
4710: OR EXISTS (

Line 4771: FROM HZ_IMP_CLASSIFICS_SG

4767: AND batch_mode_flag = p_batch_mode_flag
4768: AND rownum = 1)
4769: OR EXISTS (
4770: SELECT 'Y'
4771: FROM HZ_IMP_CLASSIFICS_SG
4772: WHERE batch_id = p_batch_id
4773: AND batch_mode_flag = p_batch_mode_flag
4774: AND rownum = 1)
4775: OR EXISTS (