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

Line 187: select /+ index(p, HZ_PARTIES_U1) / 1

183: where t.forward_rel_code = r.rc
184: and t.relationship_type = r.rt)
185: where lsd < ed
186: and exists (
187: select /*+ index(p, HZ_PARTIES_U1) */ 1
188: from hz_parties p
189: where subject_type = p.party_type
190: and sub_id = p.party_id)
191: and exists (

Line 188: from hz_parties p

184: and t.relationship_type = r.rt)
185: where lsd < ed
186: and exists (
187: select /*+ index(p, HZ_PARTIES_U1) */ 1
188: from hz_parties p
189: where subject_type = p.party_type
190: and sub_id = p.party_id)
191: and exists (
192: select /*+ index(p, HZ_PARTIES_U1) */ 1

Line 192: select /+ index(p, HZ_PARTIES_U1) / 1

188: from hz_parties p
189: where subject_type = p.party_type
190: and sub_id = p.party_id)
191: and exists (
192: select /*+ index(p, HZ_PARTIES_U1) */ 1
193: from hz_parties p
194: where object_type = p.party_type
195: and obj_id = p.party_id);
196:

Line 193: from hz_parties p

189: where subject_type = p.party_type
190: and sub_id = p.party_id)
191: and exists (
192: select /*+ index(p, HZ_PARTIES_U1) */ 1
193: from hz_parties p
194: where object_type = p.party_type
195: and obj_id = p.party_id);
196:
197: /* Combination of party_site_id and site_use_type is unique.

Line 442: AND r.subject_table_name='HZ_PARTIES'

438: AND decode(r.relationship_type,'PARENT/SUBSIDIARY','HEADQUARTERS/DIVISION',r.relationship_type)
439: =decode(rs.relationship_type,'PARENT/SUBSIDIARY','HEADQUARTERS/DIVISION',rs.relationship_type)
440: AND decode(r.relationship_code,'PARENT_OF','HEADQUARTERS_OF',r.relationship_code)
441: =decode(rs.relationship_code,'PARENT_OF','HEADQUARTERS_OF',rs.relationship_code)
442: AND r.subject_table_name='HZ_PARTIES'
443: AND r.object_table_name='HZ_PARTIES'
444: AND r.object_type='ORGANIZATION'
445: AND r.status='A'
446: AND P_SYSDATE > r.start_date

Line 443: AND r.object_table_name='HZ_PARTIES'

439: =decode(rs.relationship_type,'PARENT/SUBSIDIARY','HEADQUARTERS/DIVISION',rs.relationship_type)
440: AND decode(r.relationship_code,'PARENT_OF','HEADQUARTERS_OF',r.relationship_code)
441: =decode(rs.relationship_code,'PARENT_OF','HEADQUARTERS_OF',rs.relationship_code)
442: AND r.subject_table_name='HZ_PARTIES'
443: AND r.object_table_name='HZ_PARTIES'
444: AND r.object_type='ORGANIZATION'
445: AND r.status='A'
446: AND P_SYSDATE > r.start_date
447: AND P_SYSDATE <= nvl(r.end_date, TO_DATE('31-12-4712 00:00:01', 'DD-MM-YYYY HH24:MI:SS'))

Line 572: execute immediate 'alter sequence ' || l_schema || '.hz_parties_s cache 20000';

568: execute immediate 'alter sequence ' || l_schema || '.hz_organization_profiles_s cache 20000';
569: execute immediate 'alter sequence ' || l_schema || '.hz_org_contacts_s cache 20000';
570: execute immediate 'alter sequence ' || l_schema || '.hz_org_contact_roles_s cache 20000';
571: execute immediate 'alter sequence ' || l_schema || '.hz_orig_system_ref_s cache 20000';
572: execute immediate 'alter sequence ' || l_schema || '.hz_parties_s cache 20000';
573: execute immediate 'alter sequence ' || l_schema || '.hz_party_number_s cache 20000';
574: execute immediate 'alter sequence ' || l_schema || '.hz_party_sites_s cache 20000';
575: execute immediate 'alter sequence ' || l_schema || '.hz_party_site_number_s cache 20000';
576: execute immediate 'alter sequence ' || l_schema || '.hz_party_site_uses_s cache 20000';

Line 609: execute immediate 'alter sequence ' || l_schema || '.hz_parties_s cache 20';

605: execute immediate 'alter sequence ' || l_schema || '.hz_organization_profiles_s cache 20';
606: execute immediate 'alter sequence ' || l_schema || '.hz_org_contacts_s cache 20';
607: execute immediate 'alter sequence ' || l_schema || '.hz_org_contact_roles_s cache 20';
608: execute immediate 'alter sequence ' || l_schema || '.hz_orig_system_ref_s cache 20';
609: execute immediate 'alter sequence ' || l_schema || '.hz_parties_s cache 20';
610: execute immediate 'alter sequence ' || l_schema || '.hz_party_number_s cache 20';
611: execute immediate 'alter sequence ' || l_schema || '.hz_party_sites_s cache 20';
612: execute immediate 'alter sequence ' || l_schema || '.hz_party_site_number_s cache 20';
613: execute immediate 'alter sequence ' || l_schema || '.hz_party_site_uses_s cache 20';

Line 741: AND posr.owner_table_name = ''HZ_PARTIES''

737: AND site_sg.party_orig_system = :CP_OS
738: AND posr.orig_system = site_sg.party_orig_system
739: AND posr.orig_system_reference = site_sg.party_orig_system_reference
740: AND posr.status = ''A''
741: AND posr.owner_table_name = ''HZ_PARTIES''
742: AND psosr.orig_system = site_sg.site_orig_system
743: AND psosr.orig_system_reference = site_sg.site_orig_system_reference
744: AND psosr.status = ''A''
745: AND psosr.owner_table_name = ''HZ_PARTY_SITES''

Line 767: AND posr.owner_table_name = ''HZ_PARTIES''

763: AND cpt_sg.party_orig_system = :CP_OS
764: AND posr.orig_system = cpt_sg.party_orig_system
765: AND posr.orig_system_reference = cpt_sg.party_orig_system_reference
766: AND posr.status = ''A''
767: AND posr.owner_table_name = ''HZ_PARTIES''
768: AND cposr.orig_system = cpi.cp_orig_system
769: AND cposr.orig_system_reference = cpi.cp_orig_system_reference
770: AND cposr.status = ''A''
771: AND cposr.owner_table_name = ''HZ_CONTACT_POINTS''

Line 1214: where osr.owner_table_name = 'HZ_PARTIES'

1210: ps.party_id, osr.owner_table_id displayed_duns_party_id
1211: from hz_orig_sys_references osr,
1212: hz_imp_parties_int pi,
1213: hz_imp_parties_sg ps
1214: where osr.owner_table_name = 'HZ_PARTIES'
1215: and osr.orig_system = 'DNB'
1216: and osr.orig_system_reference = pi.displayed_duns
1217: and pi.batch_id = p_batch_id
1218: and pi.party_orig_system = 'DNB'

Line 1280: l_dss_others_err VARCHAR2(2000) := hz_dss_util_pub.get_display_name('HZ_PARTIES',null);

1276:
1277: -- Bug 3871136
1278: l_dss_person_err VARCHAR2(2000) := hz_dss_util_pub.get_display_name(null,'PERSON');
1279: l_dss_org_err VARCHAR2(2000) := hz_dss_util_pub.get_display_name(null,'ORGANIZATION');
1280: l_dss_others_err VARCHAR2(2000) := hz_dss_util_pub.get_display_name('HZ_PARTIES',null);
1281: l_dss_rel_err VARCHAR2(2000) := hz_dss_util_pub.get_display_name('HZ_RELATIONSHIPS',null);
1282: l_dss_ca_err VARCHAR2(2000) := hz_dss_util_pub.get_display_name('HZ_CODE_ASSIGNMENTS',null);
1283: l_dss_cp_err VARCHAR2(2000) := hz_dss_util_pub.get_display_name(null,'PARTY_CONTACT_POINTS');
1284: l_dss_ps_err VARCHAR2(2000) := hz_dss_util_pub.get_display_name(null,'PARTY_SITE_CONTACT_POINTS');

Line 2141: 'AR_RAPI_DESC_FLEX_INVALID', 'DFF_NAME', 'HZ_PARTIES')

2137: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2138: token1_name, token1_value)
2139: values (
2140: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',
2141: 'AR_RAPI_DESC_FLEX_INVALID', 'DFF_NAME', 'HZ_PARTIES')
2142: when (E33_FLAG is null) then
2143: into hz_imp_errors (
2144: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)
2145: values (

Line 2213: 'HZ_IMP_DUP_VAL', 'INDEX', 'HZ_PARTIES_U1', 'ENTITY', 'HZ_PARTIES')

2209: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2210: token1_name, token1_value, token2_name, token2_value)
2211: values (
2212: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',
2213: 'HZ_IMP_DUP_VAL', 'INDEX', 'HZ_PARTIES_U1', 'ENTITY', 'HZ_PARTIES')
2214: when (DUP_VAL_IDX_EXCEP_FLAG = 'B') then
2215: into hz_imp_errors (
2216: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2217: token1_name, token1_value, token2_name, token2_value)

Line 2220: 'HZ_IMP_DUP_VAL', 'INDEX', 'HZ_PARTIES_U2', 'ENTITY', 'HZ_PARTIES')

2216: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2217: token1_name, token1_value, token2_name, token2_value)
2218: values (
2219: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',
2220: 'HZ_IMP_DUP_VAL', 'INDEX', 'HZ_PARTIES_U2', 'ENTITY', 'HZ_PARTIES')
2221: when (ACTION_MISMATCH_FLAG is null) then
2222: into hz_imp_errors (
2223: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)
2224: values (

Line 3930: l_error_message := 'Invalid party_id(s) is found in hz_imp_parties_int that does not exist in hz_parties. Please correct the party_id and resubmit the batch for import. Please check error report for invalid party_id(s).';

3926: CHECK_INVALID_PARTY(P_BATCH_ID,P_REQUEST_ID,l_user_id,l_last_update_login,P_PROGRAM_ID,
3927: P_PROGRAM_APPLICATION_ID,l_return_status);
3928:
3929: IF l_return_status = 'E' THEN
3930: l_error_message := 'Invalid party_id(s) is found in hz_imp_parties_int that does not exist in hz_parties. Please correct the party_id and resubmit the batch for import. Please check error report for invalid party_id(s).';
3931: FND_FILE.PUT_LINE(FND_FILE.LOG, 'log:' || l_error_message);
3932: update_import_status(P_BATCH_ID, 'ERROR');
3933:
3934: errbuf := l_error_message;

Line 4841: from hz_parties hp

4837: batch_id=L_BATCH_ID
4838: AND hip.party_id is not null
4839: AND not exists
4840: (select 1
4841: from hz_parties hp
4842: where hp.party_id=hip.party_id
4843: );
4844:
4845: BEGIN