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_RESOURCE_PUB dependencies on HZ_ORG_CONTACTS

Line 288: FROM HZ_PARTIES PARTY , HZ_RELATIONSHIPS PARTY_REL , HZ_ORG_CONTACTS ORG_CONT ,

284: IS
285: SELECT 'Y'
286: -- SELECT PARTY.PARTY_ID PARTY_ID , ORG_CONT.PARTY_SITE_ID PARTY_SITE_ID , ORG_CONT.ORG_CONTACT_ID CONTACT_ID ,
287: -- ORG_CONT.CONTACT_NUMBER CONTACT_NUMBER , PARTY.PARTY_NAME CONTACT_NAME , CONT_ROLE.PRIMARY_FLAG PRIMARY_FLAG
288: FROM HZ_PARTIES PARTY , HZ_RELATIONSHIPS PARTY_REL , HZ_ORG_CONTACTS ORG_CONT ,
289: HZ_ORG_CONTACT_ROLES CONT_ROLE
290: WHERE PARTY.STATUS = 'A'
291: AND PARTY.PARTY_TYPE = 'PERSON'
292: AND PARTY_REL.RELATIONSHIP_ID = ORG_CONT.PARTY_RELATIONSHIP_ID

Line 309: HZ_ORG_CONTACTS ORG_CONT , HZ_ORG_CONTACT_ROLES CONT_ROLE

305: -- SELECT PARTY5.PARTY_ID PARTY_ID , ORG_CONT.PARTY_SITE_ID PARTY_SITE_ID ,
306: -- ORG_CONT.ORG_CONTACT_ID CONTACT_ID , ORG_CONT.CONTACT_NUMBER CONTACT_NUMBER ,
307: -- PARTY5.PARTY_NAME CONTACT_NAME , CONT_ROLE.PRIMARY_FLAG PRIMARY_FLAG
308: FROM HZ_PARTIES PARTY3 , HZ_PARTIES PARTY4 , HZ_PARTIES PARTY5 , HZ_RELATIONSHIPS PARTY_REL ,
309: HZ_ORG_CONTACTS ORG_CONT , HZ_ORG_CONTACT_ROLES CONT_ROLE
310: WHERE PARTY_REL.PARTY_ID = PARTY5.PARTY_ID
311: AND PARTY5.PARTY_TYPE = 'PARTY_RELATIONSHIP'
312: AND PARTY5.STATUS = 'A'
313: AND TRUNC (NVL (PARTY_REL.END_DATE, SYSDATE)) >= TRUNC (SYSDATE)

Line 336: HZ_ORG_CONTACTS ORG_CONT , HZ_ORG_CONTACT_ROLES CONT_ROLE

332: -- SELECT PARTY4.PARTY_ID PARTY_ID , ORG_CONT.PARTY_SITE_ID PARTY_SITE_ID ,
333: -- ORG_CONT.ORG_CONTACT_ID CONTACT_ID , ORG_CONT.CONTACT_NUMBER CONTACT_NUMBER ,
334: -- PARTY3.PARTY_NAME CONTACT_NAME , CONT_ROLE.PRIMARY_FLAG PRIMARY_FLAG
335: FROM HZ_PARTIES PARTY3 , HZ_PARTIES PARTY4 , HZ_RELATIONSHIPS PARTY_REL ,
336: HZ_ORG_CONTACTS ORG_CONT , HZ_ORG_CONTACT_ROLES CONT_ROLE
337: WHERE PARTY_REL.SUBJECT_ID = PARTY3.PARTY_ID
338: AND PARTY3.PARTY_TYPE = 'PERSON'
339: AND PARTY3.STATUS = 'A'
340: AND PARTY_REL.OBJECT_ID = PARTY4.PARTY_ID

Line 381: hz_org_contacts hzoc

377: AND nvl(party_site_id, 0) = nvl(l_party_site_id, 0)
378: AND contact_id = l_contact_id; */
379: -- changed the query the validate party contact id according to bug 2954064 as provided by the PRM team , sudarsana 2nd july 2004
380: FROM hz_relationships hzr,
381: hz_org_contacts hzoc
382: WHERE hzr.party_id = l_party_id
383: AND hzoc.org_contact_id = l_contact_id
384: AND hzr.directional_flag = 'F'
385: AND hzr.relationship_code = 'EMPLOYEE_OF'

Line 2655: FROM HZ_PARTIES PARTY , HZ_RELATIONSHIPS PARTY_REL , HZ_ORG_CONTACTS ORG_CONT ,

2651: IS
2652: SELECT 'Y'
2653: -- SELECT PARTY.PARTY_ID PARTY_ID , ORG_CONT.PARTY_SITE_ID PARTY_SITE_ID , ORG_CONT.ORG_CONTACT_ID CONTACT_ID ,
2654: -- ORG_CONT.CONTACT_NUMBER CONTACT_NUMBER , PARTY.PARTY_NAME CONTACT_NAME , CONT_ROLE.PRIMARY_FLAG PRIMARY_FLAG
2655: FROM HZ_PARTIES PARTY , HZ_RELATIONSHIPS PARTY_REL , HZ_ORG_CONTACTS ORG_CONT ,
2656: HZ_ORG_CONTACT_ROLES CONT_ROLE
2657: WHERE PARTY.STATUS = 'A'
2658: AND PARTY.PARTY_TYPE = 'PERSON'
2659: AND PARTY_REL.RELATIONSHIP_ID = ORG_CONT.PARTY_RELATIONSHIP_ID

Line 2676: HZ_ORG_CONTACTS ORG_CONT , HZ_ORG_CONTACT_ROLES CONT_ROLE

2672: -- SELECT PARTY5.PARTY_ID PARTY_ID , ORG_CONT.PARTY_SITE_ID PARTY_SITE_ID ,
2673: -- ORG_CONT.ORG_CONTACT_ID CONTACT_ID , ORG_CONT.CONTACT_NUMBER CONTACT_NUMBER ,
2674: -- PARTY5.PARTY_NAME CONTACT_NAME , CONT_ROLE.PRIMARY_FLAG PRIMARY_FLAG
2675: FROM HZ_PARTIES PARTY3 , HZ_PARTIES PARTY4 , HZ_PARTIES PARTY5 , HZ_RELATIONSHIPS PARTY_REL ,
2676: HZ_ORG_CONTACTS ORG_CONT , HZ_ORG_CONTACT_ROLES CONT_ROLE
2677: WHERE PARTY_REL.PARTY_ID = PARTY5.PARTY_ID
2678: AND PARTY5.PARTY_TYPE = 'PARTY_RELATIONSHIP'
2679: AND PARTY5.STATUS = 'A'
2680: AND TRUNC (NVL (PARTY_REL.END_DATE, SYSDATE)) >= TRUNC (SYSDATE)

Line 2703: HZ_ORG_CONTACTS ORG_CONT , HZ_ORG_CONTACT_ROLES CONT_ROLE

2699: -- SELECT PARTY4.PARTY_ID PARTY_ID , ORG_CONT.PARTY_SITE_ID PARTY_SITE_ID ,
2700: -- ORG_CONT.ORG_CONTACT_ID CONTACT_ID , ORG_CONT.CONTACT_NUMBER CONTACT_NUMBER ,
2701: -- PARTY3.PARTY_NAME CONTACT_NAME , CONT_ROLE.PRIMARY_FLAG PRIMARY_FLAG
2702: FROM HZ_PARTIES PARTY3 , HZ_PARTIES PARTY4 , HZ_RELATIONSHIPS PARTY_REL ,
2703: HZ_ORG_CONTACTS ORG_CONT , HZ_ORG_CONTACT_ROLES CONT_ROLE
2704: WHERE PARTY_REL.SUBJECT_ID = PARTY3.PARTY_ID
2705: AND PARTY3.PARTY_TYPE = 'PERSON'
2706: AND PARTY3.STATUS = 'A'
2707: AND PARTY_REL.OBJECT_ID = PARTY4.PARTY_ID

Line 2745: hz_org_contacts hzoc

2741: AND nvl(party_site_id, 0) = nvl(l_party_site_id, 0)
2742: AND contact_id = l_contact_id; */
2743: -- changed the query the validate party contact id according to bug 2954064 as provided by the PRM team , sudarsana 2nd july 2004
2744: FROM hz_relationships hzr,
2745: hz_org_contacts hzoc
2746: WHERE hzr.party_id = l_party_id
2747: AND hzoc.org_contact_id = l_contact_id
2748: AND hzr.directional_flag = 'F'
2749: AND hzr.relationship_code = 'EMPLOYEE_OF'