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.JTF_RS_PARTY_MERGE_PUB dependencies on HZ_CONTACT_POINTS

Line 870: HZ_CONTACT_POINTS CT_POINT1

866: PARTY.PERSON_MIDDLE_NAME,
867: PARTY.PERSON_LAST_NAME
868: FROM
869: HZ_PARTIES PARTY,
870: HZ_CONTACT_POINTS CT_POINT1
871: WHERE PARTY.PARTY_ID = p_source_id
872: AND PARTY.PARTY_TYPE NOT IN ('ORGANIZATION', 'GROUP')
873: AND CT_POINT1.OWNER_TABLE_NAME (+)= 'HZ_PARTIES'
874: AND CT_POINT1.OWNER_TABLE_ID (+)= PARTY.PARTY_ID

Line 906: HZ_CONTACT_POINTS CT_POINT1,

902: FROM
903: HZ_PARTIES PARTY,
904: HZ_PARTIES PARTY2,
905: HZ_PARTIES PARTY3,
906: HZ_CONTACT_POINTS CT_POINT1,
907: -- HZ_PARTY_RELATIONSHIPS REL
908: HZ_RELATIONSHIPS REL
909: WHERE PARTY.PARTY_ID = p_source_id
910: AND (

Line 973: HZ_CONTACT_POINTS CT_POINT1,

969: HZ_PARTIES PARTY2,
970: HZ_PARTIES PARTY3,
971: HZ_PARTY_SITES PARTY_SITE,
972: HZ_LOCATIONS LOC,
973: HZ_CONTACT_POINTS CT_POINT1,
974: -- HZ_PARTY_RELATIONSHIPS REL
975: HZ_RELATIONSHIPS REL
976: WHERE PARTY.PARTY_ID = p_source_id
977: AND (