VIEW: APPS.OTFV_ENROLLMENT_STATUSES

Source

View Text - Preformatted

SELECT bgrT.name business_group_name , btt.name enrollment_status , hr_bis.bis_decode_lookup('DELEGATE_BOOKING_STATUS',bst.type) enrollment_status_type , hr_bis.bis_decode_lookup('YES_NO',bst.default_flag) default_flag , DECODE(bst.place_used_flag,NULL,NULL, hr_bis.bis_decode_lookup('YES_NO',bst.place_used_flag )) place_used , hr_bis.bis_decode_lookup( 'YES_NO',bst.active_flag) active_flag , bst.description description , bst.comments comments , bst.type enrollment_status_type_code , bst.default_flag default_flag_code , bst.place_used_flag place_used_code , bst.active_flag active_flag_code , '_DF:OTA:OTA_BOOKING_STATUS_TYPES:bst' , bst.business_group_id business_group_id , bst.booking_status_type_id booking_status_type_id FROM hr_all_organization_units bgr , hr_all_organization_units_tl bgrT , ota_booking_status_types bst , ota_booking_status_types_tl btt WHERE bst.business_group_id = bgr.organization_id AND bgr.organization_id = bgrT.organization_id AND bgrT.language = userenv('LANG') AND bst.booking_status_type_id = btt.booking_status_type_id AND btt.language = USERENV('LANG') AND bst.business_group_id = NVL(ota_general.get_business_group_id, bst.business_group_id) WITH READ ONLY

View Text - HTML Formatted

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, BTT.NAME ENROLLMENT_STATUS
, HR_BIS.BIS_DECODE_LOOKUP('DELEGATE_BOOKING_STATUS'
, BST.TYPE) ENROLLMENT_STATUS_TYPE
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, BST.DEFAULT_FLAG) DEFAULT_FLAG
, DECODE(BST.PLACE_USED_FLAG
, NULL
, NULL
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, BST.PLACE_USED_FLAG )) PLACE_USED
, HR_BIS.BIS_DECODE_LOOKUP( 'YES_NO'
, BST.ACTIVE_FLAG) ACTIVE_FLAG
, BST.DESCRIPTION DESCRIPTION
, BST.COMMENTS COMMENTS
, BST.TYPE ENROLLMENT_STATUS_TYPE_CODE
, BST.DEFAULT_FLAG DEFAULT_FLAG_CODE
, BST.PLACE_USED_FLAG PLACE_USED_CODE
, BST.ACTIVE_FLAG ACTIVE_FLAG_CODE
, '_DF:OTA:OTA_BOOKING_STATUS_TYPES:BST'
, BST.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, BST.BOOKING_STATUS_TYPE_ID BOOKING_STATUS_TYPE_ID
FROM HR_ALL_ORGANIZATION_UNITS BGR
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
, OTA_BOOKING_STATUS_TYPES BST
, OTA_BOOKING_STATUS_TYPES_TL BTT
WHERE BST.BUSINESS_GROUP_ID = BGR.ORGANIZATION_ID
AND BGR.ORGANIZATION_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND BST.BOOKING_STATUS_TYPE_ID = BTT.BOOKING_STATUS_TYPE_ID
AND BTT.LANGUAGE = USERENV('LANG')
AND BST.BUSINESS_GROUP_ID = NVL(OTA_GENERAL.GET_BUSINESS_GROUP_ID
, BST.BUSINESS_GROUP_ID) WITH READ ONLY