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_LEARNER_ENROLL_SS dependencies on OTA_BOOKING_STATUS_TYPES_TL

Line 28: FROM ota_booking_status_types bst, ota_booking_status_types_tl bstt

24: bst.BST_INFORMATION9,bst.BST_INFORMATION10,bst.BST_INFORMATION11,
25: bst.BST_INFORMATION12,bst.BST_INFORMATION13,bst.BST_INFORMATION14,
26: bst.BST_INFORMATION15,bst.BST_INFORMATION16,bst.BST_INFORMATION17,
27: bst.BST_INFORMATION18,bst.BST_INFORMATION19,bst.BST_INFORMATION20
28: FROM ota_booking_status_types bst, ota_booking_status_types_tl bstt
29: WHERE bst.business_group_id = p_business_group_id
30: AND bst.booking_status_type_id = bstt.booking_status_type_id
31: AND bstt.language=userenv('LANG')
32: AND bst.ACTIVE_FLAG = 'Y'

Line 45: FROM ota_booking_status_types bst1, ota_booking_status_types_tl bstt1

41: AND ( (bstt.name like 'W:%' and bst.ACTIVE_FLAG = 'Y')
42: -- There are no names like W:, so a defaulted required status is
43: -- the second choice.
44: OR ( NOT EXISTS (SELECT 1
45: FROM ota_booking_status_types bst1, ota_booking_status_types_tl bstt1
46: WHERE bst1.business_group_id = p_business_group_id
47: AND bst1.booking_status_type_id = bstt1.booking_status_type_id
48: AND bstt1.language=userenv('LANG')
49: AND bst1.type =