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_CREDITRTNGS_SG

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

652: IF P_BATCH_MODE_FLAG = 'Y' THEN
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';

Line 675: DELETE HZ_IMP_CREDITRTNGS_SG

671: AND batch_mode_flag = P_BATCH_MODE_FLAG;
672: DELETE HZ_IMP_CONTACTPTS_SG
673: WHERE batch_id = P_BATCH_ID
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

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

Line 4688: FROM HZ_IMP_CREDITRTNGS_SG

4684: AND batch_mode_flag = p_batch_mode_flag
4685: AND rownum = 1)
4686: OR EXISTS (
4687: SELECT 'Y'
4688: FROM HZ_IMP_CREDITRTNGS_SG
4689: WHERE batch_id = p_batch_id
4690: AND batch_mode_flag = p_batch_mode_flag
4691: AND rownum = 1)
4692: OR EXISTS (

Line 4753: FROM HZ_IMP_CREDITRTNGS_SG

4749: AND batch_mode_flag = p_batch_mode_flag
4750: AND rownum = 1)
4751: OR EXISTS (
4752: SELECT 'Y'
4753: FROM HZ_IMP_CREDITRTNGS_SG
4754: WHERE batch_id = p_batch_id
4755: AND batch_mode_flag = p_batch_mode_flag
4756: AND rownum = 1)
4757: OR EXISTS (