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_PARTIES_INT

Line 110: from hz_imp_parties_int p_int,

106: nvl2(mosr2.orig_system_reference,
107: nvl2(nullif(mosr.owner_table_id, p_int.party_id), 'Y', null),
108: nvl2(mosr.owner_table_id, 'R', 'E')
109: ), null) new_osr_exists_flag
110: from hz_imp_parties_int p_int,
111: hz_orig_sys_references mosr, -- OSR look up
112: hz_orig_sys_references mosr2 -- look up for osr collision
113: where p_int.party_orig_system_reference = mosr.orig_system_reference (+)
114: and p_int.party_orig_system = mosr.orig_system (+)

Line 191: from hz_imp_parties_int p_int,

187: nvl2(mosr2.orig_system_reference,
188: nvl2(nullif(mosr.owner_table_id, p_int.party_id), 'Y', null),
189: nvl2(mosr.owner_table_id, 'R', 'E')
190: ), null) new_osr_exists_flag
191: from hz_imp_parties_int p_int,
192: hz_orig_sys_references mosr, -- OSR look up
193: hz_orig_sys_references mosr2 -- look up for osr collision
194: where p_int.party_orig_system_reference = mosr.orig_system_reference (+)
195: and p_int.party_orig_system = mosr.orig_system (+)

Line 229: from hz_imp_parties_int p_int,

225: p_int.party_orig_system_reference party_osr,
226: p_int.rowid int_row_id,
227: nvl2(mosr.owner_table_id, 'U', 'I') action_flag,
228: P_BATCH_MODE_FLAG, P_BATCH_ID
229: from hz_imp_parties_int p_int,
230: hz_orig_sys_references mosr
231: where p_int.party_orig_system_reference = mosr.orig_system_reference (+)
232: and p_int.party_orig_system = mosr.orig_system (+)
233: and p_int.batch_id = P_BATCH_ID

Line 263: from hz_imp_parties_int p_int,

259: p_int.party_orig_system_reference party_osr,
260: p_int.rowid int_row_id,
261: nvl2(mosr.owner_table_id, 'U', 'I') action_flag,
262: P_BATCH_MODE_FLAG, P_BATCH_ID
263: from hz_imp_parties_int p_int,
264: hz_orig_sys_references mosr
265: where p_int.party_orig_system_reference = mosr.orig_system_reference (+)
266: and p_int.party_orig_system = mosr.orig_system (+)
267: and p_int.batch_id = P_BATCH_ID

Line 1889: hz_imp_parties_int sub_int,

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'
1893: and mosr2.owner_table_name (+) = 'HZ_PARTIES'

Line 1890: hz_imp_parties_int obj_int

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'
1893: and mosr2.owner_table_name (+) = 'HZ_PARTIES'
1894: and mosr2.status (+) = 'A'

Line 1995: hz_imp_parties_int sub_int,

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'
1999: and mosr2.owner_table_name (+) = 'HZ_PARTIES'

Line 1996: hz_imp_parties_int obj_int

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'
1999: and mosr2.owner_table_name (+) = 'HZ_PARTIES'
2000: and mosr2.status (+) = 'A'

Line 2101: hz_imp_parties_int sub_int,

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'
2105: and mosr2.owner_table_name (+) = 'HZ_PARTIES'

Line 2102: hz_imp_parties_int obj_int

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'
2105: and mosr2.owner_table_name (+) = 'HZ_PARTIES'
2106: and mosr2.status (+) = 'A'

Line 2207: hz_imp_parties_int sub_int,

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'
2211: and mosr2.owner_table_name (+) = 'HZ_PARTIES'

Line 2208: hz_imp_parties_int obj_int

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'
2211: and mosr2.owner_table_name (+) = 'HZ_PARTIES'
2212: and mosr2.status (+) = 'A'

Line 2319: hz_imp_parties_int sub_int,

2315: hz_orig_sys_references cont_mosr,
2316: hz_imp_parties_sg sub_sg,
2317: hz_orig_sys_references sub_mosr,
2318: hz_imp_parties_sg obj_sg,
2319: hz_imp_parties_int sub_int,
2320: hz_imp_parties_int obj_int, /*6913856 */
2321: hz_orig_sys_references obj_mosr
2322: where cont_int.batch_id = P_BATCH_ID
2323: and cont_int.sub_orig_system = P_OS

Line 2320: hz_imp_parties_int obj_int, /6913856 /

2316: hz_imp_parties_sg sub_sg,
2317: hz_orig_sys_references sub_mosr,
2318: hz_imp_parties_sg obj_sg,
2319: hz_imp_parties_int sub_int,
2320: hz_imp_parties_int obj_int, /*6913856 */
2321: hz_orig_sys_references obj_mosr
2322: where cont_int.batch_id = P_BATCH_ID
2323: and cont_int.sub_orig_system = P_OS
2324: and cont_int.sub_orig_system_reference between P_FROM_OSR and P_TO_OSR

Line 2401: hz_imp_parties_int sub_int,

2397: hz_orig_sys_references cont_mosr,
2398: hz_imp_parties_sg sub_sg,
2399: hz_orig_sys_references sub_mosr,
2400: hz_imp_parties_sg obj_sg,
2401: hz_imp_parties_int sub_int,
2402: hz_imp_parties_int obj_int,
2403: hz_orig_sys_references obj_mosr
2404: where cont_int.batch_id = P_BATCH_ID
2405: and cont_int.sub_orig_system = P_OS

Line 2402: hz_imp_parties_int obj_int,

2398: hz_imp_parties_sg sub_sg,
2399: hz_orig_sys_references sub_mosr,
2400: hz_imp_parties_sg obj_sg,
2401: hz_imp_parties_int sub_int,
2402: hz_imp_parties_int obj_int,
2403: hz_orig_sys_references obj_mosr
2404: where cont_int.batch_id = P_BATCH_ID
2405: and cont_int.sub_orig_system = P_OS
2406: and cont_int.sub_orig_system_reference between P_FROM_OSR and P_TO_OSR