DBA Data[Home] [Help]

APPS.HZ_IMP_LOAD_SSM_MATCHING_PKG dependencies on HZ_PARTIES_S

Line 66: nvl(party_id,HZ_PARTIES_S.NextVal),

62: batch_mode_flag,
63: batch_id
64: ) values
65: (
66: nvl(party_id,HZ_PARTIES_S.NextVal),
67: party_os,
68: party_osr,
69: int_row_id,
70: action_flag,

Line 147: nvl(party_id,HZ_PARTIES_S.NextVal),

143: batch_mode_flag,
144: batch_id
145: ) values
146: (
147: nvl(party_id,HZ_PARTIES_S.NextVal),
148: party_os,
149: party_osr,
150: int_row_id,
151: action_flag,

Line 223: nvl(mosr.owner_table_id, HZ_PARTIES_S.NextVal) party_id,

219: batch_id
220: )
221: (
222: select /*+ leading(p_int) index_asc(p_int) use_nl(mosr) */
223: nvl(mosr.owner_table_id, HZ_PARTIES_S.NextVal) party_id,
224: p_int.party_orig_system party_os,
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,

Line 257: nvl(mosr.owner_table_id, HZ_PARTIES_S.NextVal) party_id,

253: batch_id
254: )
255: (
256: select /*+ leading(p_int) index_asc(p_int) use_nl(mosr) */
257: nvl(mosr.owner_table_id, HZ_PARTIES_S.NextVal) party_id,
258: p_int.party_orig_system party_os,
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,