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.OTA_UTILITY dependencies on HZ_RELATIONSHIPS

Line 2339: HZ_RELATIONSHIPS REL,

2335: HR_GENERAL.DECODE_AR_LOOKUP('CONTACT_TITLE',nvl(PARTY.PERSON_PRE_NAME_ADJUNCT,PARTY.PERSON_TITLE)) LEARNER_NAME
2336: FROM
2337: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
2338: HZ_PARTIES PARTY,
2339: HZ_RELATIONSHIPS REL,
2340: HZ_CUST_ACCOUNTS ROLE_ACCT
2341: WHERE
2342: ACCT_ROLE.PARTY_ID = REL.PARTY_ID
2343: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'

Line 2395: HZ_RELATIONSHIPS rel,

2391: CURSOR c_customer_id IS
2392: select ACCT_ROLE.cust_account_id CUSTOMER_ID
2393: from HZ_CUST_ACCOUNT_ROLES acct_role,
2394: HZ_PARTIES party,
2395: HZ_RELATIONSHIPS rel,
2396: HZ_ORG_CONTACTS org_cont,
2397: HZ_PARTIES rel_party,
2398: HZ_CUST_ACCOUNTS role_acct
2399: where acct_role.party_id = rel.party_id

Line 2751: HZ_RELATIONSHIPS rel,

2747: Cursor get_ext_lrn_party_id is
2748: select party.party_id
2749: from HZ_CUST_ACCOUNT_ROLES acct_role,
2750: HZ_PARTIES party,
2751: HZ_RELATIONSHIPS rel,
2752: HZ_ORG_CONTACTS org_cont,
2753: HZ_PARTIES rel_party,
2754: HZ_CUST_ACCOUNTS role_acct
2755: where acct_role.party_id = rel.party_id

Line 3551: HZ_RELATIONSHIPS REL,

3547: cursor get_external_email_addresses is
3548: SELECT PARTY.EMAIL_ADDRESS
3549: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
3550: HZ_PARTIES PARTY,
3551: HZ_RELATIONSHIPS REL,
3552: HZ_CUST_ACCOUNTS ROLE_ACCT,
3553: HZ_ROLE_RESPONSIBILITY ROL ,
3554: HZ_ORG_CONTACTS ORG_CONT,
3555: HZ_LOCATIONS LOC,