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_CUST_ACCOUNTS

Line 2276: HZ_CUST_ACCOUNTS ROLE_ACCT

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'
2280: AND REL.SUBJECT_ID = PARTY.PARTY_ID

Line 2334: HZ_CUST_ACCOUNTS role_acct

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
2336: and acct_role.role_type = 'CONTACT'
2337: and org_cont.party_relationship_id = rel.relationship_id
2338: and rel.subject_id = party.party_id

Line 2372: ,hz_cust_accounts cust_acct

2368:
2369: CURSOR c_customer_name(l_customer_id IN ota_delegate_bookings.customer_id%TYPE) IS
2370: select substrb(party.party_name,1,50)
2371: from hz_parties party
2372: ,hz_cust_accounts cust_acct
2373: where
2374: cust_acct.party_id = party.party_id
2375: and cust_acct.cust_account_id = l_customer_id;
2376:

Line 2690: HZ_CUST_ACCOUNTS role_acct

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
2692: and acct_role.role_type = 'CONTACT'
2693: and org_cont.party_relationship_id = rel.relationship_id
2694: and rel.subject_id = party.party_id