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_CUS_BUS dependencies on OTA_CHAT_USERS

Line 37: , ota_chat_users cus

33: cursor csr_sec_grp is
34: select pbg.security_group_id,
35: pbg.legislation_code
36: from per_business_groups_perf pbg
37: , ota_chat_users cus
38: where cus.chat_id = p_chat_id
39: and cus.person_id = p_person_id
40: and cus.contact_id = p_contact_id
41: and pbg.business_group_id = cus.business_group_id;

Line 125: , ota_chat_users cus

121: --
122: cursor csr_leg_code is
123: select pbg.legislation_code
124: from per_business_groups_perf pbg
125: , ota_chat_users cus
126: where cus.chat_id = p_chat_id
127: and cus.person_id = p_person_id
128: and cus.contact_id = p_contact_id
129: and pbg.business_group_id = cus.business_group_id;