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.

[Home] [Help]

APPS.HZ_IMP_LOAD_SSM_MATCHING_PKG dependencies on HZ_CODE_ASSIGNMENTS

Line 972: hz_code_assignments_s.nextval) ca_id, p_batch_mode_flag, p_batch_id,

968: ca_int_w_pid.start_date_active, ca_int_w_pid.end_date_active,
969: ca_int_w_pid.pid, ca_int_w_pid.party_os, ca_int_w_pid.party_osr,
970: ca_int_w_pid.int_row_id, nvl2(hz_ca.code_assignment_id, 'U', 'I')
971: action_flag, nvl(hz_ca.code_assignment_id,
972: hz_code_assignments_s.nextval) ca_id, p_batch_mode_flag, p_batch_id,
973: -- set as not primary if already a primary,
974: -- pick on primary per party per class category
975: -- if any of the code assignment set as primary in interface
976: nvl2(hz_ca3.code_assignment_id, null,

Line 982: from hz_code_assignments hz_ca,

978: (partition by pid, ca_int_w_pid.class_category
979: order by ca_int_w_pid.primary_flag
980: desc nulls last),
981: 1, ca_int_w_pid.primary_flag, null)) primary_flag
982: from hz_code_assignments hz_ca,
983: hz_code_assignments hz_ca3,
984: (
985: select /*+ leading(ca_int) index_asc(ca_int) use_hash(party_sg) use_nl(mosr) */
986: nvl(nvl(nvl(ca_int.party_id,party_sg.party_id),osr_ch_tbl.entity_id),mosr.owner_table_id) pid,

Line 983: hz_code_assignments hz_ca3,

979: order by ca_int_w_pid.primary_flag
980: desc nulls last),
981: 1, ca_int_w_pid.primary_flag, null)) primary_flag
982: from hz_code_assignments hz_ca,
983: hz_code_assignments hz_ca3,
984: (
985: select /*+ leading(ca_int) index_asc(ca_int) use_hash(party_sg) use_nl(mosr) */
986: nvl(nvl(nvl(ca_int.party_id,party_sg.party_id),osr_ch_tbl.entity_id),mosr.owner_table_id) pid,
987: ca_int.party_orig_system party_os,

Line 1068: hz_code_assignments_s.nextval) ca_id, p_batch_mode_flag, p_batch_id,

1064: ca_int_w_pid.start_date_active, ca_int_w_pid.end_date_active,
1065: ca_int_w_pid.pid, ca_int_w_pid.party_os, ca_int_w_pid.party_osr,
1066: ca_int_w_pid.int_row_id, nvl2(hz_ca.code_assignment_id, 'U', 'I')
1067: action_flag, nvl(hz_ca.code_assignment_id,
1068: hz_code_assignments_s.nextval) ca_id, p_batch_mode_flag, p_batch_id,
1069: -- set as not primary if already a primary,
1070: -- pick on primary per party per class category
1071: -- if any of the code assignment set as primary in interface
1072: nvl2(hz_ca3.code_assignment_id, null,

Line 1078: from hz_code_assignments hz_ca,

1074: (partition by pid, ca_int_w_pid.class_category
1075: order by ca_int_w_pid.primary_flag
1076: desc nulls last),
1077: 1, ca_int_w_pid.primary_flag, null)) primary_flag
1078: from hz_code_assignments hz_ca,
1079: hz_code_assignments hz_ca3,
1080: (
1081: select /*+ leading(ca_int) index_asc(ca_int) use_hash(party_sg) use_nl(mosr) */
1082: nvl(nvl(nvl(ca_int.party_id,party_sg.party_id),osr_ch_tbl.entity_id),mosr.owner_table_id) pid,

Line 1079: hz_code_assignments hz_ca3,

1075: order by ca_int_w_pid.primary_flag
1076: desc nulls last),
1077: 1, ca_int_w_pid.primary_flag, null)) primary_flag
1078: from hz_code_assignments hz_ca,
1079: hz_code_assignments hz_ca3,
1080: (
1081: select /*+ leading(ca_int) index_asc(ca_int) use_hash(party_sg) use_nl(mosr) */
1082: nvl(nvl(nvl(ca_int.party_id,party_sg.party_id),osr_ch_tbl.entity_id),mosr.owner_table_id) pid,
1083: ca_int.party_orig_system party_os,

Line 1163: hz_code_assignments_s.nextval) ca_id, p_batch_mode_flag, p_batch_id,

1159: ca_int_w_pid.start_date_active, ca_int_w_pid.end_date_active,
1160: ca_int_w_pid.pid, ca_int_w_pid.party_os, ca_int_w_pid.party_osr,
1161: ca_int_w_pid.int_row_id, nvl2(hz_ca.code_assignment_id, 'U', 'I')
1162: action_flag, nvl(hz_ca.code_assignment_id,
1163: hz_code_assignments_s.nextval) ca_id, p_batch_mode_flag, p_batch_id,
1164: -- set as not primary if already a primary,
1165: -- pick on primary per party per class category
1166: -- if any of the code assignment set as primary in interface
1167: nvl2(hz_ca3.code_assignment_id, null,

Line 1173: from hz_code_assignments hz_ca,

1169: (partition by pid, ca_int_w_pid.class_category
1170: order by ca_int_w_pid.primary_flag
1171: desc nulls last),
1172: 1, ca_int_w_pid.primary_flag, null)) primary_flag
1173: from hz_code_assignments hz_ca,
1174: hz_code_assignments hz_ca3,
1175: (
1176: select /*+ leading(ca_int) index_asc(ca_int) use_hash(party_sg) use_nl(mosr) */
1177: nvl(nvl(nvl(ca_int.party_id,party_sg.party_id),osr_ch_tbl.entity_id),mosr.owner_table_id) pid,

Line 1174: hz_code_assignments hz_ca3,

1170: order by ca_int_w_pid.primary_flag
1171: desc nulls last),
1172: 1, ca_int_w_pid.primary_flag, null)) primary_flag
1173: from hz_code_assignments hz_ca,
1174: hz_code_assignments hz_ca3,
1175: (
1176: select /*+ leading(ca_int) index_asc(ca_int) use_hash(party_sg) use_nl(mosr) */
1177: nvl(nvl(nvl(ca_int.party_id,party_sg.party_id),osr_ch_tbl.entity_id),mosr.owner_table_id) pid,
1178: ca_int.party_orig_system party_os,

Line 1259: hz_code_assignments_s.nextval) ca_id, p_batch_mode_flag, p_batch_id,

1255: ca_int_w_pid.start_date_active, ca_int_w_pid.end_date_active,
1256: ca_int_w_pid.pid, ca_int_w_pid.party_os, ca_int_w_pid.party_osr,
1257: ca_int_w_pid.int_row_id, nvl2(hz_ca.code_assignment_id, 'U', 'I')
1258: action_flag, nvl(hz_ca.code_assignment_id,
1259: hz_code_assignments_s.nextval) ca_id, p_batch_mode_flag, p_batch_id,
1260: -- set as not primary if already a primary,
1261: -- pick on primary per party per class category
1262: -- if any of the code assignment set as primary in interface
1263: nvl2(hz_ca3.code_assignment_id, null,

Line 1269: from hz_code_assignments hz_ca,

1265: (partition by pid, ca_int_w_pid.class_category
1266: order by ca_int_w_pid.primary_flag
1267: desc nulls last),
1268: 1, ca_int_w_pid.primary_flag, null)) primary_flag
1269: from hz_code_assignments hz_ca,
1270: hz_code_assignments hz_ca3,
1271: (
1272: select /*+ leading(ca_int) index_asc(ca_int) use_hash(party_sg) use_nl(mosr) */
1273: nvl(nvl(nvl(ca_int.party_id,party_sg.party_id),osr_ch_tbl.entity_id),mosr.owner_table_id) pid,

Line 1270: hz_code_assignments hz_ca3,

1266: order by ca_int_w_pid.primary_flag
1267: desc nulls last),
1268: 1, ca_int_w_pid.primary_flag, null)) primary_flag
1269: from hz_code_assignments hz_ca,
1270: hz_code_assignments hz_ca3,
1271: (
1272: select /*+ leading(ca_int) index_asc(ca_int) use_hash(party_sg) use_nl(mosr) */
1273: nvl(nvl(nvl(ca_int.party_id,party_sg.party_id),osr_ch_tbl.entity_id),mosr.owner_table_id) pid,
1274: ca_int.party_orig_system party_os,