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

Line 26: FROM ota_booking_status_types bst, ota_booking_status_types_tl bstt

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

Line 41: FROM ota_booking_status_types bst1, ota_booking_status_types_tl bstt1

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