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 2436: FROM HZ_PARTIES PARTY , HZ_RELATIONSHIPS PARTY_REL , HZ_ORG_CONTACTS ORG_CONT ,

2432: IS
2433: SELECT 'Y'
2434: -- SELECT PARTY.PARTY_ID PARTY_ID , ORG_CONT.PARTY_SITE_ID PARTY_SITE_ID , ORG_CONT.ORG_CONTACT_ID CONTACT_ID ,
2435: -- ORG_CONT.CONTACT_NUMBER CONTACT_NUMBER , PARTY.PARTY_NAME CONTACT_NAME , CONT_ROLE.PRIMARY_FLAG PRIMARY_FLAG
2436: FROM HZ_PARTIES PARTY , HZ_RELATIONSHIPS PARTY_REL , HZ_ORG_CONTACTS ORG_CONT ,
2437: HZ_ORG_CONTACT_ROLES CONT_ROLE
2438: WHERE PARTY.STATUS = 'A'
2439: AND PARTY.PARTY_TYPE = 'PERSON'
2440: AND PARTY_REL.RELATIONSHIP_ID = ORG_CONT.PARTY_RELATIONSHIP_ID

Line 2457: HZ_ORG_CONTACTS ORG_CONT , HZ_ORG_CONTACT_ROLES CONT_ROLE

2453: -- SELECT PARTY5.PARTY_ID PARTY_ID , ORG_CONT.PARTY_SITE_ID PARTY_SITE_ID ,
2454: -- ORG_CONT.ORG_CONTACT_ID CONTACT_ID , ORG_CONT.CONTACT_NUMBER CONTACT_NUMBER ,
2455: -- PARTY5.PARTY_NAME CONTACT_NAME , CONT_ROLE.PRIMARY_FLAG PRIMARY_FLAG
2456: FROM HZ_PARTIES PARTY3 , HZ_PARTIES PARTY4 , HZ_PARTIES PARTY5 , HZ_RELATIONSHIPS PARTY_REL ,
2457: HZ_ORG_CONTACTS ORG_CONT , HZ_ORG_CONTACT_ROLES CONT_ROLE
2458: WHERE PARTY_REL.PARTY_ID = PARTY5.PARTY_ID
2459: AND PARTY5.PARTY_TYPE = 'PARTY_RELATIONSHIP'
2460: AND PARTY5.STATUS = 'A'
2461: AND TRUNC (NVL (PARTY_REL.END_DATE, SYSDATE)) >= TRUNC (SYSDATE)

Line 2484: HZ_ORG_CONTACTS ORG_CONT , HZ_ORG_CONTACT_ROLES CONT_ROLE

2480: -- SELECT PARTY4.PARTY_ID PARTY_ID , ORG_CONT.PARTY_SITE_ID PARTY_SITE_ID ,
2481: -- ORG_CONT.ORG_CONTACT_ID CONTACT_ID , ORG_CONT.CONTACT_NUMBER CONTACT_NUMBER ,
2482: -- PARTY3.PARTY_NAME CONTACT_NAME , CONT_ROLE.PRIMARY_FLAG PRIMARY_FLAG
2483: FROM HZ_PARTIES PARTY3 , HZ_PARTIES PARTY4 , HZ_RELATIONSHIPS PARTY_REL ,
2484: HZ_ORG_CONTACTS ORG_CONT , HZ_ORG_CONTACT_ROLES CONT_ROLE
2485: WHERE PARTY_REL.SUBJECT_ID = PARTY3.PARTY_ID
2486: AND PARTY3.PARTY_TYPE = 'PERSON'
2487: AND PARTY3.STATUS = 'A'
2488: AND PARTY_REL.OBJECT_ID = PARTY4.PARTY_ID

Line 2526: hz_org_contacts hzoc

2522: AND nvl(party_site_id, 0) = nvl(l_party_site_id, 0)
2523: AND contact_id = l_contact_id; */
2524: -- changed the query the validate party contact id according to bug 2954064 as provided by the PRM team , sudarsana 2nd july 2004
2525: FROM hz_relationships hzr,
2526: hz_org_contacts hzoc
2527: WHERE hzr.party_id = l_party_id
2528: AND hzoc.org_contact_id = l_contact_id
2529: AND hzr.directional_flag = 'F'
2530: AND hzr.relationship_code = 'EMPLOYEE_OF'