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_CPT_PKG dependencies on HZ_PARTIES

Line 973: nvl2(ps.party_site_id, ''HZ_PARTY_SITES'', ''HZ_PARTIES'') owner_table_name,

969: ps.party_site_id,
970: ps.contact_point_id,
971: nvl(ps.primary_flag,''N'') primary_flag,
972: nullif(pi.created_by_module, :G_MISS_CHAR) created_by_module,
973: nvl2(ps.party_site_id, ''HZ_PARTY_SITES'', ''HZ_PARTIES'') owner_table_name,
974: nvl(ps.party_site_id, ps.party_id) owner_table_id,
975: nvl2(contact_point_type_l.lookup_code, ''Y'', null) contact_point_type_l,
976: nvl2(email_format_l.lookup_code, ''Y'', null) email_format_l,
977: nvl2(cp_purpose_l.lookup_code, ''Y'', null) cp_purpose_l,

Line 994: ''HZ_PARTIES''))) owner_table_error, */

990: and (orig_system, orig_system_reference, owner_table_name) in (
991: (pi.site_orig_system, pi.site_orig_system_reference,
992: ''HZ_PARTY_SITES''),
993: (pi.party_orig_system, pi.party_orig_system_reference,
994: ''HZ_PARTIES''))) owner_table_error, */
995: ps.error_flag,
996: hp.party_id party_owner_table_id,
997: mosr_site.owner_table_id site_owner_table_id
998: from hz_imp_contactpts_int pi,

Line 1001: hz_parties hp,

997: mosr_site.owner_table_id site_owner_table_id
998: from hz_imp_contactpts_int pi,
999: hz_imp_contactpts_sg ps,
1000: --hz_orig_sys_references mosr_party,
1001: hz_parties hp,
1002: hz_orig_sys_references mosr_site,
1003: --(select distinct phone_country_code from hz_phone_country_codes) hpc,--3401319
1004: (select 0 a from dual union all select 1 a from dual) tc,--3401319
1005: fnd_timezones_b ht,

Line 1190: and hz_cpt.owner_table_name= ''HZ_PARTIES''

1186: 'select cpt_sg.party_id, int.contact_point_type,
1187: ( select hz_cpt.contact_point_id
1188: from hz_contact_points hz_cpt
1189: where hz_cpt.owner_table_id = cpt_sg.party_id
1190: and hz_cpt.owner_table_name= ''HZ_PARTIES''
1191: and hz_cpt.CONTACT_POINT_TYPE = int.contact_point_type
1192: and rownum = 1
1193: ) contact_point_id
1194: from HZ_IMP_TMP_ERRORS err_table,

Line 1217: update hz_parties hz_pty

1213: l_error_party_id,l_error_cpt_type, l_error_cpt_id;
1214: close primary_flag_err_cursor;
1215: /* Start of bug 7383480
1216: forall i in 1..l_error_party_id.count
1217: update hz_parties hz_pty
1218: set (email_address,url ) =
1219: ( select email_address,url
1220: from hz_contact_points
1221: where contact_point_id = l_error_cpt_id(i)

Line 1226: update hz_parties hz_pty

1222: )
1223: where hz_pty.party_id = l_error_party_id(i);
1224: */
1225: forall i in 1..l_error_party_id.count
1226: update hz_parties hz_pty
1227: set email_address =
1228: ( select email_address
1229: from hz_contact_points
1230: where contact_point_id = l_error_cpt_id(i)

Line 1237: update hz_parties hz_pty

1233: where hz_pty.party_id = l_error_party_id(i)
1234: and l_error_cpt_type(i)= 'EMAIL';
1235:
1236: forall i in 1..l_error_party_id.count
1237: update hz_parties hz_pty
1238: set url =
1239: ( select url
1240: from hz_contact_points
1241: where contact_point_id = l_error_cpt_id(i)

Line 1283: update hz_parties hz_pty

1279: l_update_party_id, l_update_cpt_id,l_update_cpt_type;
1280: close de_norm_cursor;
1281: /* Start of bug 7383480
1282: forall i in 1..l_update_party_id.count
1283: update hz_parties hz_pty
1284: set (email_address,url ) =
1285: ( select email_address,url
1286: from hz_contact_points
1287: where contact_point_id = l_update_cpt_id(i)

Line 1292: update hz_parties hz_pty

1288: )
1289: where hz_pty.party_id = l_update_party_id(i);
1290: */
1291: forall i in 1..l_update_party_id.count
1292: update hz_parties hz_pty
1293: set email_address =( select email_address
1294: from hz_contact_points
1295: where contact_point_id = l_update_cpt_id(i)
1296: and contact_point_type='EMAIL')

Line 1302: update hz_parties hz_pty

1298: and l_update_cpt_type(i) = 'EMAIL' ;
1299:
1300:
1301: forall i in 1..l_update_party_id.count
1302: update hz_parties hz_pty
1303: set url =( select url
1304: from hz_contact_points
1305: where contact_point_id = l_update_cpt_id(i)
1306: and contact_point_type='WEB')

Line 1441: nvl2(ps.party_site_id, ''HZ_PARTY_SITES'', ''HZ_PARTIES'') owner_table_name,

1437: ps.party_site_id,
1438: ps.contact_point_id,
1439: nvl(hp.primary_flag,''N'') primary_flag, /* Bug No: 3917168 */
1440: nullif(pi.created_by_module,:G_MISS_CHAR) created_by_module,
1441: nvl2(ps.party_site_id, ''HZ_PARTY_SITES'', ''HZ_PARTIES'') owner_table_name,
1442: nvl(ps.party_site_id, ps.party_id) owner_table_id,
1443: nvl2(nullif(pi.insert_update_flag, ps.action_flag),null, ''Y'') action_mismatch_error,
1444: decode(nullif(pi.contact_point_type,:G_MISS_CHAR),null,null,hp.contact_point_type,''Y'',null) cpt_type_updatable_error,
1445: /*decode(hp.CONTACT_POINT_TYPE,null,''Y'',''WEB'',nvl2(nullif(pi.CONTACT_POINT_PURPOSE,:G_MISS_CHAR),nvl2(cp_purpose_web_l.lookup_code,''Y'',null),''Y'' ),

Line 1853: update hz_parties hz_pty

1849: -- record errors
1850: report_errors(P_DML_RECORD,'U', l_dml_exception);
1851:
1852: ForAll j in 1..l_contact_point_id.count
1853: update hz_parties hz_pty
1854: set (email_address,url ) =
1855: ( select email_address,url
1856: from hz_contact_points
1857: where contact_point_id = l_contact_point_id(j)