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 461: into hz_imp_osr_change (

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

Line 523: hz_imp_osr_change osr_change_tbl

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

Line 616: hz_imp_osr_change addr_osr_ch_tbl,

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

Line 636: hz_imp_osr_change party_osr_ch_tbl

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

Line 729: hz_imp_osr_change addr_osr_ch_tbl,

725: ) desc nulls last,
726: cp_mosr.owner_table_id nulls last), 1, 'Y', null) ) primary_flag,
727: cpi_cosr.contact_point_type
728: from hz_imp_addresses_sg asg,
729: hz_imp_osr_change addr_osr_ch_tbl,
730: hz_contact_points hz_cpt_pri,
731: hz_orig_sys_references ps_mosr,
732: hz_orig_sys_references cp_mosr,
733: (

Line 749: hz_imp_osr_change party_osr_ch_tbl

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

Line 847: hz_imp_osr_change osr_ch_tbl

843: rating_org, cr_int.rowid int_row_id
844: from hz_imp_creditrtngs_int cr_int,
845: hz_imp_parties_sg party_sg,
846: hz_orig_sys_references mosr,
847: hz_imp_osr_change osr_ch_tbl
848: where cr_int.interface_status = 'C'
849: and cr_int.batch_id = P_BATCH_ID
850: and cr_int.party_orig_system = P_OS
851: and cr_int.batch_id = party_sg.batch_id(+)

Line 906: hz_imp_osr_change osr_ch_tbl

902: rating_org, cr_int.rowid int_row_id
903: from hz_imp_creditrtngs_int cr_int,
904: hz_imp_parties_sg party_sg,
905: hz_orig_sys_references mosr,
906: hz_imp_osr_change osr_ch_tbl
907: where cr_int.interface_status is null
908: and cr_int.batch_id = P_BATCH_ID
909: and cr_int.party_orig_system = P_OS
910: and cr_int.batch_id = party_sg.batch_id(+)

Line 1000: hz_imp_osr_change osr_ch_tbl

996: ca_int.primary_flag
997: from hz_imp_classifics_int ca_int,
998: hz_imp_parties_sg party_sg,
999: hz_orig_sys_references mosr,
1000: hz_imp_osr_change osr_ch_tbl
1001: where ca_int.interface_status = 'C'
1002: and ca_int.batch_id = p_batch_id
1003: and ca_int.party_orig_system = p_os
1004: and ca_int.party_orig_system_reference between p_from_osr and p_to_osr

Line 1096: hz_imp_osr_change osr_ch_tbl

1092: ca_int.primary_flag
1093: from hz_imp_classifics_int ca_int,
1094: hz_imp_parties_sg party_sg,
1095: hz_orig_sys_references mosr,
1096: hz_imp_osr_change osr_ch_tbl
1097: where ca_int.interface_status = 'C'
1098: and ca_int.batch_id = p_batch_id
1099: and ca_int.party_orig_system = p_os
1100: and ca_int.party_orig_system_reference between p_from_osr and p_to_osr

Line 1191: hz_imp_osr_change osr_ch_tbl

1187: ca_int.primary_flag
1188: from hz_imp_classifics_int ca_int,
1189: hz_imp_parties_sg party_sg,
1190: hz_orig_sys_references mosr,
1191: hz_imp_osr_change osr_ch_tbl
1192: where ca_int.interface_status is null
1193: and ca_int.batch_id = p_batch_id
1194: and ca_int.party_orig_system = p_os
1195: and ca_int.party_orig_system_reference between p_from_osr and p_to_osr

Line 1287: hz_imp_osr_change osr_ch_tbl

1283: ca_int.primary_flag
1284: from hz_imp_classifics_int ca_int,
1285: hz_imp_parties_sg party_sg,
1286: hz_orig_sys_references mosr,
1287: hz_imp_osr_change osr_ch_tbl
1288: where ca_int.interface_status is null
1289: and ca_int.batch_id = p_batch_id
1290: and ca_int.party_orig_system = p_os
1291: and ca_int.party_orig_system_reference between p_from_osr and p_to_osr

Line 1413: hz_imp_osr_change osr_ch_tbl

1409: fr_int.rowid int_row_id
1410: from hz_imp_finreports_int fr_int,
1411: hz_imp_parties_sg party_sg,
1412: hz_orig_sys_references mosr,
1413: hz_imp_osr_change osr_ch_tbl
1414: where fr_int.interface_status = 'C'
1415: and fr_int.batch_id = P_BATCH_ID
1416: and fr_int.party_orig_system = P_OS
1417: and fr_int.party_orig_system_reference between P_FROM_OSR and P_TO_OSR

Line 1509: hz_imp_osr_change osr_ch_tbl

1505: fr_int.rowid int_row_id
1506: from hz_imp_finreports_int fr_int,
1507: hz_imp_parties_sg party_sg,
1508: hz_orig_sys_references mosr,
1509: hz_imp_osr_change osr_ch_tbl
1510: where fr_int.interface_status is null
1511: and fr_int.batch_id = P_BATCH_ID
1512: and fr_int.party_orig_system = P_OS
1513: and fr_int.party_orig_system_reference between P_FROM_OSR and P_TO_OSR

Line 1647: hz_imp_osr_change osr_ch_tbl

1643: fn_int.batch_id
1644: from hz_imp_finnumbers_int fn_int,
1645: hz_imp_parties_sg party_sg,
1646: hz_orig_sys_references mosr,
1647: hz_imp_osr_change osr_ch_tbl
1648: where fn_int.interface_status = 'C'
1649: and fn_int.batch_id = P_BATCH_ID
1650: and fn_int.party_orig_system = P_OS
1651: and fn_int.party_orig_system_reference between P_FROM_OSR and P_TO_OSR

Line 1783: hz_imp_osr_change osr_ch_tbl

1779: fn_int.batch_id
1780: from hz_imp_finnumbers_int fn_int,
1781: hz_imp_parties_sg party_sg,
1782: hz_orig_sys_references mosr,
1783: hz_imp_osr_change osr_ch_tbl
1784: where fn_int.interface_status is null
1785: and fn_int.batch_id = P_BATCH_ID
1786: and fn_int.party_orig_system = P_OS
1787: and fn_int.party_orig_system_reference between P_FROM_OSR and P_TO_OSR

Line 1904: hz_imp_osr_change sub_osr_ch_tbl,

1900: hz_orig_sys_references mosr,
1901: hz_orig_sys_references mosr2,
1902: HZ_IMP_PARTIES_SG PARTY_SGA,
1903: HZ_IMP_PARTIES_SG PARTY_SGB,
1904: hz_imp_osr_change sub_osr_ch_tbl,
1905: hz_imp_osr_change obj_osr_ch_tbl,
1906: hz_imp_parties_int sub_int,
1907: hz_imp_parties_int obj_int
1908: where mosr.owner_table_name (+) = 'HZ_PARTIES'

Line 1905: hz_imp_osr_change obj_osr_ch_tbl,

1901: hz_orig_sys_references mosr2,
1902: HZ_IMP_PARTIES_SG PARTY_SGA,
1903: HZ_IMP_PARTIES_SG PARTY_SGB,
1904: hz_imp_osr_change sub_osr_ch_tbl,
1905: hz_imp_osr_change obj_osr_ch_tbl,
1906: hz_imp_parties_int sub_int,
1907: hz_imp_parties_int obj_int
1908: where mosr.owner_table_name (+) = 'HZ_PARTIES'
1909: and mosr.status (+) = 'A'

Line 2014: hz_imp_osr_change sub_osr_ch_tbl,

2010: hz_orig_sys_references mosr,
2011: hz_orig_sys_references mosr2,
2012: HZ_IMP_PARTIES_SG PARTY_SGA,
2013: HZ_IMP_PARTIES_SG PARTY_SGB,
2014: hz_imp_osr_change sub_osr_ch_tbl,
2015: hz_imp_osr_change obj_osr_ch_tbl,
2016: hz_imp_parties_int sub_int,
2017: hz_imp_parties_int obj_int
2018: where mosr.owner_table_name (+) = 'HZ_PARTIES'

Line 2015: hz_imp_osr_change obj_osr_ch_tbl,

2011: hz_orig_sys_references mosr2,
2012: HZ_IMP_PARTIES_SG PARTY_SGA,
2013: HZ_IMP_PARTIES_SG PARTY_SGB,
2014: hz_imp_osr_change sub_osr_ch_tbl,
2015: hz_imp_osr_change obj_osr_ch_tbl,
2016: hz_imp_parties_int sub_int,
2017: hz_imp_parties_int obj_int
2018: where mosr.owner_table_name (+) = 'HZ_PARTIES'
2019: and mosr.status (+) = 'A'

Line 2124: hz_imp_osr_change sub_osr_ch_tbl,

2120: hz_orig_sys_references mosr,
2121: hz_orig_sys_references mosr2,
2122: HZ_IMP_PARTIES_SG PARTY_SGA,
2123: HZ_IMP_PARTIES_SG PARTY_SGB,
2124: hz_imp_osr_change sub_osr_ch_tbl,
2125: hz_imp_osr_change obj_osr_ch_tbl,
2126: hz_imp_parties_int sub_int,
2127: hz_imp_parties_int obj_int
2128: where mosr.owner_table_name (+) = 'HZ_PARTIES'

Line 2125: hz_imp_osr_change obj_osr_ch_tbl,

2121: hz_orig_sys_references mosr2,
2122: HZ_IMP_PARTIES_SG PARTY_SGA,
2123: HZ_IMP_PARTIES_SG PARTY_SGB,
2124: hz_imp_osr_change sub_osr_ch_tbl,
2125: hz_imp_osr_change obj_osr_ch_tbl,
2126: hz_imp_parties_int sub_int,
2127: hz_imp_parties_int obj_int
2128: where mosr.owner_table_name (+) = 'HZ_PARTIES'
2129: and mosr.status (+) = 'A'

Line 2233: hz_imp_osr_change sub_osr_ch_tbl,

2229: hz_orig_sys_references mosr,
2230: hz_orig_sys_references mosr2,
2231: HZ_IMP_PARTIES_SG PARTY_SGA,
2232: HZ_IMP_PARTIES_SG PARTY_SGB,
2233: hz_imp_osr_change sub_osr_ch_tbl,
2234: hz_imp_osr_change obj_osr_ch_tbl,
2235: hz_imp_parties_int sub_int,
2236: hz_imp_parties_int obj_int
2237: where mosr.owner_table_name (+) = 'HZ_PARTIES'

Line 2234: hz_imp_osr_change obj_osr_ch_tbl,

2230: hz_orig_sys_references mosr2,
2231: HZ_IMP_PARTIES_SG PARTY_SGA,
2232: HZ_IMP_PARTIES_SG PARTY_SGB,
2233: hz_imp_osr_change sub_osr_ch_tbl,
2234: hz_imp_osr_change obj_osr_ch_tbl,
2235: hz_imp_parties_int sub_int,
2236: hz_imp_parties_int obj_int
2237: where mosr.owner_table_name (+) = 'HZ_PARTIES'
2238: and mosr.status (+) = 'A'