[Home] [Help]
View: OTFV_ENROLLMENT_STATUSES
Product: | OTA - Learning Management |
Description: | Business view template from which the flexfield view is generated. |
Implementation/DBA Data: |
APPS.OTFV_ENROLLMENT_STATUSES
|
View Text
SELECT BGRT.NAME BUSINESS_GROUP_NAME
, BST.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
, '_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
WHERE BST.BUSINESS_GROUP_ID = BGR.ORGANIZATION_ID
AND BGR.ORGANIZATION_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND BST.BUSINESS_GROUP_ID = NVL(OTA_GENERAL.GET_BUSINESS_GROUP_ID
, BST.BUSINESS_GROUP_ID) WITH READ ONLY
Columns
Name |
BUSINESS_GROUP_NAME |
ENROLLMENT_STATUS |
ENROLLMENT_STATUS_TYPE |
DEFAULT_FLAG |
PLACE_USED |
ACTIVE_FLAG |
DESCRIPTION |
COMMENTS |
"_DF" |
BUSINESS_GROUP_ID |
BOOKING_STATUS_TYPE_ID |