APPS.HZ_IMP_LOAD_WRAPPER dependencies on HZ_IMP_CONTACTPTS_SG

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

651:
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';

Line 672: DELETE HZ_IMP_CONTACTPTS_SG

668: AND batch_mode_flag = P_BATCH_MODE_FLAG;
669: DELETE HZ_IMP_ADDRESSES_SG
670: WHERE batch_id = P_BATCH_ID
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

Line 758: FROM HZ_IMP_CONTACTPTS_SG cpt_sg,HZ_IMP_CONTACTPTS_INT cpi,

754: ';
755:
756: l_cleanup_ssm_cpt_qry VARCHAR2(4000) :=
757: ' SELECT cposr.rowid,posr.owner_table_id
758: FROM HZ_IMP_CONTACTPTS_SG cpt_sg,HZ_IMP_CONTACTPTS_INT cpi,
759: HZ_ORIG_SYS_REFERENCES posr,
760: HZ_ORIG_SYS_REFERENCES cposr
761: WHERE cpt_sg.batch_id = :CP_BATCH_ID
762: AND cpt_sg.batch_mode_flag = :CP_BATCH_MODE_FLAG

Line 807: from hz_imp_contactpts_sg hcs, hz_orig_sys_references hos, hz_contact_points hcp_new,hz_contact_points hcp_old

803: ';
804:
805: l_cleanup_ssm_cpt_dnb VARCHAR2(4000) :=
806: ' select hos.rowid, hcp_old.primary_flag, hcp_old.rowid,hcp_new.rowid
807: from hz_imp_contactpts_sg hcs, hz_orig_sys_references hos, hz_contact_points hcp_new,hz_contact_points hcp_old
808: where hcs.party_orig_system=''DNB''
809: and hcs.old_cp_orig_system_ref=hos.orig_system_reference
810: and hos.orig_system=hcs.party_orig_system
811: and hos.owner_table_name=''HZ_CONTACT_POINTS''

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

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

Line 4682: FROM HZ_IMP_CONTACTPTS_SG

4678: AND batch_mode_flag = p_batch_mode_flag
4679: AND rownum = 1)
4680: OR EXISTS (
4681: SELECT 'Y'
4682: FROM HZ_IMP_CONTACTPTS_SG
4683: WHERE batch_id = p_batch_id
4684: AND batch_mode_flag = p_batch_mode_flag
4685: AND rownum = 1)
4686: OR EXISTS (

Line 4747: FROM HZ_IMP_CONTACTPTS_SG

4743: AND batch_mode_flag = p_batch_mode_flag
4744: AND rownum = 1)
4745: OR EXISTS (
4746: SELECT 'Y'
4747: FROM HZ_IMP_CONTACTPTS_SG
4748: WHERE batch_id = p_batch_id
4749: AND batch_mode_flag = p_batch_mode_flag
4750: AND rownum = 1)
4751: OR EXISTS (