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 1906: hz_imp_parties_int sub_int,

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

Line 1907: hz_imp_parties_int obj_int

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

Line 2016: hz_imp_parties_int sub_int,

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

Line 2017: hz_imp_parties_int obj_int

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

Line 2126: hz_imp_parties_int sub_int,

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

Line 2127: hz_imp_parties_int obj_int

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

Line 2235: hz_imp_parties_int sub_int,

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

Line 2236: hz_imp_parties_int obj_int

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

Line 2349: hz_imp_parties_int sub_int,

2345: hz_orig_sys_references cont_mosr,
2346: hz_imp_parties_sg sub_sg,
2347: hz_orig_sys_references sub_mosr,
2348: hz_imp_parties_sg obj_sg,
2349: hz_imp_parties_int sub_int,
2350: hz_imp_parties_int obj_int, /*6913856 */
2351: hz_orig_sys_references obj_mosr
2352: where cont_int.batch_id = P_BATCH_ID
2353: and cont_int.sub_orig_system = P_OS

Line 2350: hz_imp_parties_int obj_int, /6913856 /

2346: hz_imp_parties_sg sub_sg,
2347: hz_orig_sys_references sub_mosr,
2348: hz_imp_parties_sg obj_sg,
2349: hz_imp_parties_int sub_int,
2350: hz_imp_parties_int obj_int, /*6913856 */
2351: hz_orig_sys_references obj_mosr
2352: where cont_int.batch_id = P_BATCH_ID
2353: and cont_int.sub_orig_system = P_OS
2354: and cont_int.sub_orig_system_reference between P_FROM_OSR and P_TO_OSR

Line 2431: hz_imp_parties_int sub_int,

2427: hz_orig_sys_references cont_mosr,
2428: hz_imp_parties_sg sub_sg,
2429: hz_orig_sys_references sub_mosr,
2430: hz_imp_parties_sg obj_sg,
2431: hz_imp_parties_int sub_int,
2432: hz_imp_parties_int obj_int,
2433: hz_orig_sys_references obj_mosr
2434: where cont_int.batch_id = P_BATCH_ID
2435: and cont_int.sub_orig_system = P_OS

Line 2432: hz_imp_parties_int obj_int,

2428: hz_imp_parties_sg sub_sg,
2429: hz_orig_sys_references sub_mosr,
2430: hz_imp_parties_sg obj_sg,
2431: hz_imp_parties_int sub_int,
2432: hz_imp_parties_int obj_int,
2433: hz_orig_sys_references obj_mosr
2434: where cont_int.batch_id = P_BATCH_ID
2435: and cont_int.sub_orig_system = P_OS
2436: and cont_int.sub_orig_system_reference between P_FROM_OSR and P_TO_OSR