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_ORIG_SYS_REFERENCES

Line 9: TYPE OWNER_TABLE_ID IS TABLE OF HZ_ORIG_SYS_REFERENCES.OWNER_TABLE_ID%TYPE;

5:
6: -- Bug 5264069
7: TYPE cleanup_ssm_pid_csr_type IS REF CURSOR;
8: TYPE ROWID IS TABLE OF VARCHAR2(50);
9: TYPE OWNER_TABLE_ID IS TABLE OF HZ_ORIG_SYS_REFERENCES.OWNER_TABLE_ID%TYPE;
10:
11: TYPE T_ORIG_SYS_REF_ID IS TABLE OF HZ_ORIG_SYS_REFERENCES.ORIG_SYSTEM_REF_ID%TYPE;
12: TYPE T_PARTY_SITE_ID IS TABLE OF HZ_PARTY_SITES.PARTY_SITE_ID%TYPE;
13:

Line 11: TYPE T_ORIG_SYS_REF_ID IS TABLE OF HZ_ORIG_SYS_REFERENCES.ORIG_SYSTEM_REF_ID%TYPE;

7: TYPE cleanup_ssm_pid_csr_type IS REF CURSOR;
8: TYPE ROWID IS TABLE OF VARCHAR2(50);
9: TYPE OWNER_TABLE_ID IS TABLE OF HZ_ORIG_SYS_REFERENCES.OWNER_TABLE_ID%TYPE;
10:
11: TYPE T_ORIG_SYS_REF_ID IS TABLE OF HZ_ORIG_SYS_REFERENCES.ORIG_SYSTEM_REF_ID%TYPE;
12: TYPE T_PARTY_SITE_ID IS TABLE OF HZ_PARTY_SITES.PARTY_SITE_ID%TYPE;
13:
14: l_row_id ROWID;
15: l_row_id_new ROWID;

Line 733: HZ_ORIG_SYS_REFERENCES posr,

729:
730: l_cleanup_ssm_site_qry VARCHAR2(4000) :=
731: ' SELECT psosr.rowid,posr.owner_table_id
732: FROM HZ_IMP_ADDRESSES_SG site_sg,
733: HZ_ORIG_SYS_REFERENCES posr,
734: HZ_ORIG_SYS_REFERENCES psosr
735: WHERE site_sg.batch_id = :CP_BATCH_ID
736: AND site_sg.batch_mode_flag = :CP_BATCH_MODE_FLAG
737: AND site_sg.party_orig_system = :CP_OS

Line 734: HZ_ORIG_SYS_REFERENCES psosr

730: l_cleanup_ssm_site_qry VARCHAR2(4000) :=
731: ' SELECT psosr.rowid,posr.owner_table_id
732: FROM HZ_IMP_ADDRESSES_SG site_sg,
733: HZ_ORIG_SYS_REFERENCES posr,
734: HZ_ORIG_SYS_REFERENCES psosr
735: WHERE site_sg.batch_id = :CP_BATCH_ID
736: AND site_sg.batch_mode_flag = :CP_BATCH_MODE_FLAG
737: AND site_sg.party_orig_system = :CP_OS
738: AND posr.orig_system = site_sg.party_orig_system

Line 759: HZ_ORIG_SYS_REFERENCES posr,

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
763: AND cpt_sg.party_orig_system = :CP_OS

Line 760: HZ_ORIG_SYS_REFERENCES cposr

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
763: AND cpt_sg.party_orig_system = :CP_OS
764: AND posr.orig_system = cpt_sg.party_orig_system

Line 785: from hz_imp_addresses_sg has, hz_orig_sys_references hos, hz_party_sites hps_new,hz_party_sites hps_old

781:
782:
783: l_cleanup_ssm_add_dnb VARCHAR2(4000) :=
784: ' select hos.rowid, hps_old.identifying_Address_flag, hps_old.rowid,hps_new.rowid
785: from hz_imp_addresses_sg has, hz_orig_sys_references hos, hz_party_sites hps_new,hz_party_sites hps_old
786: where has.site_orig_system=''DNB''
787: and has.old_site_orig_system_ref=hos.orig_system_reference
788: and hos.orig_system=has.site_orig_system
789: and hos.owner_table_name=''HZ_PARTY_SITES''

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 833: update hz_orig_sys_references set status = 'I', end_date_active = sysdate

829:
830: c_cleanup_ssm_pid cleanup_ssm_pid_csr_type;
831:
832: BEGIN
833: update hz_orig_sys_references set status = 'I', end_date_active = sysdate
834: where rowid in (
835: select row_id from (
836: select /*+ parallel(osr) */ rowid row_id, orig_system_ref_id osrid, orig_system_reference osr,
837: owner_table_name, rank() over

Line 839: from hz_orig_sys_references osr

835: select row_id from (
836: select /*+ parallel(osr) */ rowid row_id, orig_system_ref_id osrid, orig_system_reference osr,
837: owner_table_name, rank() over
838: (partition by orig_system_reference, owner_table_name order by last_update_date desc, orig_system_ref_id desc) rn
839: from hz_orig_sys_references osr
840: where osr.orig_system = P_CONTENT_SRC_TYPE
841: and osr.status = 'A'
842: and osr.end_date_active is null
843: ) r

Line 846: -- Set the HZ_ORIG_SYS_REFERENCES.party_id of party site to be the current

842: and osr.end_date_active is null
843: ) r
844: where rn > 1);
845:
846: -- Set the HZ_ORIG_SYS_REFERENCES.party_id of party site to be the current
847: -- active party in SSM
848: l_last_fetch := FALSE;
849:
850: OPEN c_cleanup_ssm_pid FOR l_cleanup_ssm_site_qry

Line 862: UPDATE HZ_ORIG_SYS_REFERENCES

858: EXIT;
859: END IF;
860:
861: FORALL j IN l_row_id.FIRST.. l_row_id.LAST
862: UPDATE HZ_ORIG_SYS_REFERENCES
863: SET party_id = l_party_owner_table_id(j)
864: WHERE rowid = l_row_id(j);
865:
866: IF l_last_fetch = TRUE THEN

Line 872: -- Set the HZ_ORIG_SYS_REFERENCES.party_id of contact point to be the current

868: END IF;
869: END LOOP;
870: CLOSE c_cleanup_ssm_pid;
871:
872: -- Set the HZ_ORIG_SYS_REFERENCES.party_id of contact point to be the current
873: -- active party in SSM
874: l_last_fetch := FALSE;
875: OPEN c_cleanup_ssm_pid FOR l_cleanup_ssm_cpt_qry
876: USING P_batch_id,P_batch_mode_flag, P_ORIG_SYSTEM,P_batch_id,P_REQUEST_ID ;

Line 888: UPDATE HZ_ORIG_SYS_REFERENCES

884: EXIT;
885: END IF;
886:
887: FORALL j IN l_row_id.FIRST.. l_row_id.LAST
888: UPDATE HZ_ORIG_SYS_REFERENCES
889: SET party_id = l_party_owner_table_id(j)
890: WHERE rowid = l_row_id(j);
891:
892: IF l_last_fetch = TRUE THEN

Line 915: UPDATE HZ_ORIG_SYS_REFERENCES

911: END IF;
912:
913:
914: FORALL j IN l_row_id.FIRST.. l_row_id.LAST
915: UPDATE HZ_ORIG_SYS_REFERENCES
916: SET status='I',end_date_active = sysdate
917: WHERE rowid = l_row_id(j);
918:
919: FORALL j IN l_row_id_old.FIRST.. l_row_id_old.LAST

Line 952: UPDATE HZ_ORIG_SYS_REFERENCES

948: END IF;
949:
950:
951: FORALL j IN l_row_id.FIRST.. l_row_id.LAST
952: UPDATE HZ_ORIG_SYS_REFERENCES
953: SET status='I',end_date_active = sysdate
954: WHERE rowid = l_row_id(j);
955:
956: FORALL j IN l_row_id_old.FIRST.. l_row_id_old.LAST

Line 1211: from hz_orig_sys_references osr,

1207:
1208: CURSOR c_displayed_duns(p_batch_id number, p_batch_mode_flag varchar2) IS
1209: select /*+ parallel(pi) leading (pi) use_nl(ps) use_nl(osr) */
1210: ps.party_id, osr.owner_table_id displayed_duns_party_id
1211: from hz_orig_sys_references osr,
1212: hz_imp_parties_int pi,
1213: hz_imp_parties_sg ps
1214: where osr.owner_table_name = 'HZ_PARTIES'
1215: and osr.orig_system = 'DNB'

Line 4060: fnd_stats.gather_table_stats('AR', 'HZ_ORIG_SYS_REFERENCES', 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);
4061: END IF;
4062:
4063: -- get the start error_id sequence number
4064: SELECT hz_imp_errors_s.NEXTVAL INTO l_start_error_id FROM dual;