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 409: and code.owner_table_name = 'HZ_RELATIONSHIP_TYPES'

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

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

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

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

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