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_MERGE_DUP_PVT dependencies on HZ_RELATIONSHIP_TYPES

Line 410: and code.owner_table_name = 'HZ_RELATIONSHIP_TYPES'

406: select count(distinct code.owner_table_id)
407: from hz_code_assignments code
408: where code.class_category = 'RELATIONSHIP_TYPE_GROUP'
409: and code.class_code = 'PARTY_REL_GRP_CONTACTS'
410: and code.owner_table_name = 'HZ_RELATIONSHIP_TYPES'
411: and exists ( select 1 from hz_relationship_types rt,
412: HZ_RELATIONSHIPS r
413: where r.relationship_id = p_relationship_id
414: and r.relationship_type = rt.relationship_type

Line 411: and exists ( select 1 from hz_relationship_types rt,

407: from hz_code_assignments code
408: where code.class_category = 'RELATIONSHIP_TYPE_GROUP'
409: and code.class_code = 'PARTY_REL_GRP_CONTACTS'
410: and code.owner_table_name = 'HZ_RELATIONSHIP_TYPES'
411: and exists ( select 1 from hz_relationship_types rt,
412: HZ_RELATIONSHIPS r
413: where r.relationship_id = p_relationship_id
414: and r.relationship_type = rt.relationship_type
415: and r.relationship_code = rt.forward_rel_code

Line 1799: --OR exists (select 1 from hz_relationship_types where relationship_type = cp_party_relationship_type

1795: FROM HZ_RELATIONSHIPS r
1796: WHERE subject_id = cp_subj_id
1797: AND object_id = cp_obj_id
1798: AND relationship_code = cp_party_rel_code
1799: --OR exists (select 1 from hz_relationship_types where relationship_type = cp_party_relationship_type
1800: --and forward_code=backward_code))
1801: AND ((start_date between from_start_date and from_end_date)
1802: or (nvl(end_date,to_date('12/31/4712','MM/DD/YYYY')) between from_start_date and from_end_date)
1803: or(start_datefrom_end_date))