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_LO_UTILITY dependencies on HZ_CUST_ACCOUNT_ROLES

Line 191: from hz_cust_account_roles acct_role,

187:
188: cursor contact(
189: p_party_id hz_parties.party_id%type) is
190: select acct_role.cust_account_role_id
191: from hz_cust_account_roles acct_role,
192: hz_relationships rel,
193: hz_cust_accounts role_acct
194: where acct_role.party_id = rel.party_id and
195: acct_role.role_type = 'CONTACT' and

Line 544: hz_cust_account_roles acct_role,

540: book.object_version_number
541: from ota_events ev,
542: ota_delegate_bookings book,
543: ota_booking_status_types stype,
544: hz_cust_account_roles acct_role,
545: hz_relationships rel,
546: hz_cust_accounts role_acct
547: where nvl(ev.course_start_date, sysdate) <= sysdate and
548: book.event_id = ev.event_id and

Line 708: hz_cust_account_roles acct_role,

704: ota_offerings offr,
705: ota_learning_objects lo,
706: ota_delegate_bookings book,
707: ota_booking_status_types stype,
708: hz_cust_account_roles acct_role,
709: hz_relationships rel,
710: hz_cust_accounts role_acct,
711: ota_activity_versions act
712: where lo.source_learning_object_id = p_lo_id and

Line 1680: from hz_cust_account_roles acct_role,

1676:
1677: cursor get_delegate_contact(
1678: p_party_id hz_parties.party_id%type) is
1679: select acct_role.cust_account_role_id
1680: from hz_cust_account_roles acct_role,
1681: hz_relationships rel,
1682: hz_cust_accounts role_acct
1683: where acct_role.party_id = rel.party_id and
1684: acct_role.role_type = 'CONTACT' and