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_SSM_MATCHING_PKG dependencies on HZ_IMP_OSR_CHANGE

Line 79: into hz_imp_osr_change (

75: )
76: when (
77: old_osr is not null
78: ) then
79: into hz_imp_osr_change (
80: entity_name,
81: new_osr_exists_flag,
82: OLD_ORIG_SYSTEM_REFERENCE,
83: NEW_ORIG_SYSTEM_REFERENCE,

Line 160: into hz_imp_osr_change (

156: )
157: when (
158: old_osr is not null
159: ) then
160: into hz_imp_osr_change (
161: entity_name,
162: new_osr_exists_flag,
163: OLD_ORIG_SYSTEM_REFERENCE,
164: NEW_ORIG_SYSTEM_REFERENCE,

Line 330: into hz_imp_osr_change (

326: )
327: when (
328: psosr <> old_psosr
329: ) then
330: into hz_imp_osr_change (
331: entity_name,
332: new_osr_exists_flag,
333: OLD_ORIG_SYSTEM_REFERENCE,
334: NEW_ORIG_SYSTEM_REFERENCE,

Line 393: hz_imp_osr_change osr_change_tbl

389: nvl2(nullif(ps_int.party_id,mosr.owner_table_id),'Y',null) owning_pty_chg_flag
390: from hz_imp_addresses_int ps_int,
391: hz_imp_parties_sg psg,
392: hz_orig_sys_references mosr,
393: hz_imp_osr_change osr_change_tbl
394: where mosr.owner_table_name (+) = 'HZ_PARTIES'
395: and mosr.status (+) = 'A'
396: and ps_int.batch_id = P_BATCH_ID
397: and ps_int.party_orig_system = P_OS

Line 460: into hz_imp_osr_change (

456: )
457: when (
458: psosr <> old_psosr
459: ) then
460: into hz_imp_osr_change (
461: entity_name,
462: new_osr_exists_flag,
463: OLD_ORIG_SYSTEM_REFERENCE,
464: NEW_ORIG_SYSTEM_REFERENCE,

Line 522: hz_imp_osr_change osr_change_tbl

518: nvl2(nullif(ps_int.party_id,mosr.owner_table_id),'Y',null) owning_pty_chg_flag
519: from hz_imp_addresses_int ps_int,
520: hz_imp_parties_sg psg,
521: hz_orig_sys_references mosr,
522: hz_imp_osr_change osr_change_tbl
523: where mosr.owner_table_name (+) = 'HZ_PARTIES'
524: and mosr.status (+) = 'A'
525: and ps_int.batch_id = P_BATCH_ID
526: and ps_int.party_orig_system = P_OS

Line 614: hz_imp_osr_change addr_osr_ch_tbl,

610: ) desc nulls last,
611: cp_mosr.owner_table_id nulls last), 1, 'Y', null) ) primary_flag,
612: cpi_cosr.contact_point_type
613: from hz_imp_addresses_sg asg,
614: hz_imp_osr_change addr_osr_ch_tbl,
615: hz_contact_points hz_cpt_pri,
616: hz_orig_sys_references ps_mosr,
617: hz_orig_sys_references cp_mosr,
618: (

Line 634: hz_imp_osr_change party_osr_ch_tbl

630: nvl2(nullif(cp_int.party_id,mosr.owner_table_id),'Y',null) owning_pty_chg_flag
631: from hz_imp_contactpts_int cp_int,
632: hz_imp_parties_sg psg,
633: hz_orig_sys_references mosr,
634: hz_imp_osr_change party_osr_ch_tbl
635: where cp_int.interface_status = 'C'
636: and cp_int.batch_id = P_BATCH_ID
637: and cp_int.party_orig_system = P_OS
638: and cp_int.party_orig_system_reference between P_FROM_OSR and P_TO_OSR

Line 725: hz_imp_osr_change addr_osr_ch_tbl,

721: ) desc nulls last,
722: cp_mosr.owner_table_id nulls last), 1, 'Y', null) ) primary_flag,
723: cpi_cosr.contact_point_type
724: from hz_imp_addresses_sg asg,
725: hz_imp_osr_change addr_osr_ch_tbl,
726: hz_contact_points hz_cpt_pri,
727: hz_orig_sys_references ps_mosr,
728: hz_orig_sys_references cp_mosr,
729: (

Line 745: hz_imp_osr_change party_osr_ch_tbl

741: nvl2(nullif(cp_int.party_id,mosr.owner_table_id),'Y',null) owning_pty_chg_flag
742: from hz_imp_contactpts_int cp_int,
743: hz_imp_parties_sg psg,
744: hz_orig_sys_references mosr,
745: hz_imp_osr_change party_osr_ch_tbl
746: where cp_int.interface_status is null
747: and cp_int.batch_id = P_BATCH_ID
748: and cp_int.party_orig_system = P_OS
749: and cp_int.party_orig_system_reference between P_FROM_OSR and P_TO_OSR

Line 841: hz_imp_osr_change osr_ch_tbl

837: rating_org, cr_int.rowid int_row_id
838: from hz_imp_creditrtngs_int cr_int,
839: hz_imp_parties_sg party_sg,
840: hz_orig_sys_references mosr,
841: hz_imp_osr_change osr_ch_tbl
842: where cr_int.interface_status = 'C'
843: and cr_int.batch_id = P_BATCH_ID
844: and cr_int.party_orig_system = P_OS
845: and cr_int.batch_id = party_sg.batch_id(+)

Line 899: hz_imp_osr_change osr_ch_tbl

895: rating_org, cr_int.rowid int_row_id
896: from hz_imp_creditrtngs_int cr_int,
897: hz_imp_parties_sg party_sg,
898: hz_orig_sys_references mosr,
899: hz_imp_osr_change osr_ch_tbl
900: where cr_int.interface_status is null
901: and cr_int.batch_id = P_BATCH_ID
902: and cr_int.party_orig_system = P_OS
903: and cr_int.batch_id = party_sg.batch_id(+)

Line 992: hz_imp_osr_change osr_ch_tbl

988: ca_int.primary_flag
989: from hz_imp_classifics_int ca_int,
990: hz_imp_parties_sg party_sg,
991: hz_orig_sys_references mosr,
992: hz_imp_osr_change osr_ch_tbl
993: where ca_int.interface_status = 'C'
994: and ca_int.batch_id = p_batch_id
995: and ca_int.party_orig_system = p_os
996: and ca_int.party_orig_system_reference between p_from_osr and p_to_osr

Line 1087: hz_imp_osr_change osr_ch_tbl

1083: ca_int.primary_flag
1084: from hz_imp_classifics_int ca_int,
1085: hz_imp_parties_sg party_sg,
1086: hz_orig_sys_references mosr,
1087: hz_imp_osr_change osr_ch_tbl
1088: where ca_int.interface_status = 'C'
1089: and ca_int.batch_id = p_batch_id
1090: and ca_int.party_orig_system = p_os
1091: and ca_int.party_orig_system_reference between p_from_osr and p_to_osr

Line 1181: hz_imp_osr_change osr_ch_tbl

1177: ca_int.primary_flag
1178: from hz_imp_classifics_int ca_int,
1179: hz_imp_parties_sg party_sg,
1180: hz_orig_sys_references mosr,
1181: hz_imp_osr_change osr_ch_tbl
1182: where ca_int.interface_status is null
1183: and ca_int.batch_id = p_batch_id
1184: and ca_int.party_orig_system = p_os
1185: and ca_int.party_orig_system_reference between p_from_osr and p_to_osr

Line 1276: hz_imp_osr_change osr_ch_tbl

1272: ca_int.primary_flag
1273: from hz_imp_classifics_int ca_int,
1274: hz_imp_parties_sg party_sg,
1275: hz_orig_sys_references mosr,
1276: hz_imp_osr_change osr_ch_tbl
1277: where ca_int.interface_status is null
1278: and ca_int.batch_id = p_batch_id
1279: and ca_int.party_orig_system = p_os
1280: and ca_int.party_orig_system_reference between p_from_osr and p_to_osr

Line 1401: hz_imp_osr_change osr_ch_tbl

1397: fr_int.rowid int_row_id
1398: from hz_imp_finreports_int fr_int,
1399: hz_imp_parties_sg party_sg,
1400: hz_orig_sys_references mosr,
1401: hz_imp_osr_change osr_ch_tbl
1402: where fr_int.interface_status = 'C'
1403: and fr_int.batch_id = P_BATCH_ID
1404: and fr_int.party_orig_system = P_OS
1405: and fr_int.party_orig_system_reference between P_FROM_OSR and P_TO_OSR

Line 1496: hz_imp_osr_change osr_ch_tbl

1492: fr_int.rowid int_row_id
1493: from hz_imp_finreports_int fr_int,
1494: hz_imp_parties_sg party_sg,
1495: hz_orig_sys_references mosr,
1496: hz_imp_osr_change osr_ch_tbl
1497: where fr_int.interface_status is null
1498: and fr_int.batch_id = P_BATCH_ID
1499: and fr_int.party_orig_system = P_OS
1500: and fr_int.party_orig_system_reference between P_FROM_OSR and P_TO_OSR

Line 1633: hz_imp_osr_change osr_ch_tbl

1629: fn_int.batch_id
1630: from hz_imp_finnumbers_int fn_int,
1631: hz_imp_parties_sg party_sg,
1632: hz_orig_sys_references mosr,
1633: hz_imp_osr_change osr_ch_tbl
1634: where fn_int.interface_status = 'C'
1635: and fn_int.batch_id = P_BATCH_ID
1636: and fn_int.party_orig_system = P_OS
1637: and fn_int.party_orig_system_reference between P_FROM_OSR and P_TO_OSR

Line 1768: hz_imp_osr_change osr_ch_tbl

1764: fn_int.batch_id
1765: from hz_imp_finnumbers_int fn_int,
1766: hz_imp_parties_sg party_sg,
1767: hz_orig_sys_references mosr,
1768: hz_imp_osr_change osr_ch_tbl
1769: where fn_int.interface_status is null
1770: and fn_int.batch_id = P_BATCH_ID
1771: and fn_int.party_orig_system = P_OS
1772: and fn_int.party_orig_system_reference between P_FROM_OSR and P_TO_OSR

Line 1887: hz_imp_osr_change sub_osr_ch_tbl,

1883: hz_orig_sys_references mosr,
1884: hz_orig_sys_references mosr2,
1885: HZ_IMP_PARTIES_SG PARTY_SGA,
1886: HZ_IMP_PARTIES_SG PARTY_SGB,
1887: hz_imp_osr_change sub_osr_ch_tbl,
1888: hz_imp_osr_change obj_osr_ch_tbl,
1889: hz_imp_parties_int sub_int,
1890: hz_imp_parties_int obj_int
1891: where mosr.owner_table_name (+) = 'HZ_PARTIES'

Line 1888: hz_imp_osr_change obj_osr_ch_tbl,

1884: hz_orig_sys_references mosr2,
1885: HZ_IMP_PARTIES_SG PARTY_SGA,
1886: HZ_IMP_PARTIES_SG PARTY_SGB,
1887: hz_imp_osr_change sub_osr_ch_tbl,
1888: hz_imp_osr_change obj_osr_ch_tbl,
1889: hz_imp_parties_int sub_int,
1890: hz_imp_parties_int obj_int
1891: where mosr.owner_table_name (+) = 'HZ_PARTIES'
1892: and mosr.status (+) = 'A'

Line 1993: hz_imp_osr_change sub_osr_ch_tbl,

1989: hz_orig_sys_references mosr,
1990: hz_orig_sys_references mosr2,
1991: HZ_IMP_PARTIES_SG PARTY_SGA,
1992: HZ_IMP_PARTIES_SG PARTY_SGB,
1993: hz_imp_osr_change sub_osr_ch_tbl,
1994: hz_imp_osr_change obj_osr_ch_tbl,
1995: hz_imp_parties_int sub_int,
1996: hz_imp_parties_int obj_int
1997: where mosr.owner_table_name (+) = 'HZ_PARTIES'

Line 1994: hz_imp_osr_change obj_osr_ch_tbl,

1990: hz_orig_sys_references mosr2,
1991: HZ_IMP_PARTIES_SG PARTY_SGA,
1992: HZ_IMP_PARTIES_SG PARTY_SGB,
1993: hz_imp_osr_change sub_osr_ch_tbl,
1994: hz_imp_osr_change obj_osr_ch_tbl,
1995: hz_imp_parties_int sub_int,
1996: hz_imp_parties_int obj_int
1997: where mosr.owner_table_name (+) = 'HZ_PARTIES'
1998: and mosr.status (+) = 'A'

Line 2099: hz_imp_osr_change sub_osr_ch_tbl,

2095: hz_orig_sys_references mosr,
2096: hz_orig_sys_references mosr2,
2097: HZ_IMP_PARTIES_SG PARTY_SGA,
2098: HZ_IMP_PARTIES_SG PARTY_SGB,
2099: hz_imp_osr_change sub_osr_ch_tbl,
2100: hz_imp_osr_change obj_osr_ch_tbl,
2101: hz_imp_parties_int sub_int,
2102: hz_imp_parties_int obj_int
2103: where mosr.owner_table_name (+) = 'HZ_PARTIES'

Line 2100: hz_imp_osr_change obj_osr_ch_tbl,

2096: hz_orig_sys_references mosr2,
2097: HZ_IMP_PARTIES_SG PARTY_SGA,
2098: HZ_IMP_PARTIES_SG PARTY_SGB,
2099: hz_imp_osr_change sub_osr_ch_tbl,
2100: hz_imp_osr_change obj_osr_ch_tbl,
2101: hz_imp_parties_int sub_int,
2102: hz_imp_parties_int obj_int
2103: where mosr.owner_table_name (+) = 'HZ_PARTIES'
2104: and mosr.status (+) = 'A'

Line 2205: hz_imp_osr_change sub_osr_ch_tbl,

2201: hz_orig_sys_references mosr,
2202: hz_orig_sys_references mosr2,
2203: HZ_IMP_PARTIES_SG PARTY_SGA,
2204: HZ_IMP_PARTIES_SG PARTY_SGB,
2205: hz_imp_osr_change sub_osr_ch_tbl,
2206: hz_imp_osr_change obj_osr_ch_tbl,
2207: hz_imp_parties_int sub_int,
2208: hz_imp_parties_int obj_int
2209: where mosr.owner_table_name (+) = 'HZ_PARTIES'

Line 2206: hz_imp_osr_change obj_osr_ch_tbl,

2202: hz_orig_sys_references mosr2,
2203: HZ_IMP_PARTIES_SG PARTY_SGA,
2204: HZ_IMP_PARTIES_SG PARTY_SGB,
2205: hz_imp_osr_change sub_osr_ch_tbl,
2206: hz_imp_osr_change obj_osr_ch_tbl,
2207: hz_imp_parties_int sub_int,
2208: hz_imp_parties_int obj_int
2209: where mosr.owner_table_name (+) = 'HZ_PARTIES'
2210: and mosr.status (+) = 'A'