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 2275: HZ_RELATIONSHIPS REL,

2271: HR_GENERAL.DECODE_AR_LOOKUP('CONTACT_TITLE',nvl(PARTY.PERSON_PRE_NAME_ADJUNCT,PARTY.PERSON_TITLE)) LEARNER_NAME
2272: FROM
2273: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
2274: HZ_PARTIES PARTY,
2275: HZ_RELATIONSHIPS REL,
2276: HZ_CUST_ACCOUNTS ROLE_ACCT
2277: WHERE
2278: ACCT_ROLE.PARTY_ID = REL.PARTY_ID
2279: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'

Line 2331: HZ_RELATIONSHIPS rel,

2327: CURSOR c_customer_id IS
2328: select ACCT_ROLE.cust_account_id CUSTOMER_ID
2329: from HZ_CUST_ACCOUNT_ROLES acct_role,
2330: HZ_PARTIES party,
2331: HZ_RELATIONSHIPS rel,
2332: HZ_ORG_CONTACTS org_cont,
2333: HZ_PARTIES rel_party,
2334: HZ_CUST_ACCOUNTS role_acct
2335: where acct_role.party_id = rel.party_id

Line 2687: HZ_RELATIONSHIPS rel,

2683: Cursor get_ext_lrn_party_id is
2684: select party.party_id
2685: from HZ_CUST_ACCOUNT_ROLES acct_role,
2686: HZ_PARTIES party,
2687: HZ_RELATIONSHIPS rel,
2688: HZ_ORG_CONTACTS org_cont,
2689: HZ_PARTIES rel_party,
2690: HZ_CUST_ACCOUNTS role_acct
2691: where acct_role.party_id = rel.party_id