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_IMP_RES_PVT dependencies on HZ_RELATIONSHIPS

Line 275: FROM hz_relationships hzr,

271: -- cursor for party contact
272: CURSOR party_contact_cur(l_party_id IN NUMBER)
273: IS
274: SELECT hzoc.org_contact_id CONTACT_ID
275: FROM hz_relationships hzr,
276: hz_org_contacts hzoc
277: WHERE hzr.party_id = l_party_id
278: AND hzr.directional_flag = 'F'
279: AND hzr.relationship_code = 'EMPLOYEE_OF'

Line 312: HZ_RELATIONSHIPS REL

308: PARTY.PERSON_LAST_NAME
309: FROM HZ_PARTIES PARTY,
310: HZ_CONTACT_POINTS CT_POINT1,
311: -- HZ_PARTY_RELATIONSHIPS REL
312: HZ_RELATIONSHIPS REL
313: WHERE PARTY.PARTY_ID = l_person_id
314: AND (
315: ( PARTY.PARTY_TYPE = 'ORGANIZATION'
316: AND