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

Line 27: FROM ota_booking_status_types bst, ota_booking_status_types_tl bstt

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

Line 42: FROM ota_booking_status_types bst1, ota_booking_status_types_tl bstt1

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