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 126: from hz_cust_account_roles acct_role,

122:
123: cursor contact(
124: p_party_id hz_parties.party_id%type) is
125: select acct_role.cust_account_role_id
126: from hz_cust_account_roles acct_role,
127: hz_relationships rel,
128: hz_cust_accounts role_acct
129: where acct_role.party_id = rel.party_id and
130: acct_role.role_type = 'CONTACT' and

Line 255: hz_cust_account_roles acct_role,

251: book.object_version_number
252: from ota_events ev,
253: ota_delegate_bookings book,
254: ota_booking_status_types stype,
255: hz_cust_account_roles acct_role,
256: hz_relationships rel,
257: hz_cust_accounts role_acct
258: where nvl(ev.course_start_date, sysdate) <= sysdate and
259: book.event_id = ev.event_id and

Line 406: hz_cust_account_roles acct_role,

402: ota_offerings offr,
403: ota_learning_objects lo,
404: ota_delegate_bookings book,
405: ota_booking_status_types stype,
406: hz_cust_account_roles acct_role,
407: hz_relationships rel,
408: hz_cust_accounts role_acct
409: where lo.source_learning_object_id = p_lo_id and
410: lo.learning_object_id = offr.learning_object_id and