View: OTFV_HR_RESTRICTED_EVENTS

Product:	OTA - Learning Management
Description:	Business view template from which the flexfield view is generated.
Implementation/DBA Data:	APPS.OTFV_HR_RESTRICTED_EVENTS

View Text

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, EVT.TITLE EVENT_TITLE
, EVT.COMMENTS EVENT_COMMENTS
, EVT.COURSE_START_DATE EVENT_START_DATE
, EVT.COURSE_END_DATE EVENT_END_DATE
, EVT.COURSE_START_TIME EVENT_START_TIME
, EVT.COURSE_END_TIME EVENT_END_TIME
, EVT.DURATION EVENT_DURATION
, DECODE(EVT.DURATION_UNITS
, NULL
, NULL
, HR_BIS.BIS_DECODE_LOOKUP('FREQUENCY'
, EVT.DURATION_UNITS)) EVENT_DURATION_UNITS
, DECODE(EVT.SECURE_EVENT_FLAG
, NULL
, NULL
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, EVT.SECURE_EVENT_FLAG)) SECURE_EVENT
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, SUBSTR(OTA_EVT_SHD.RESOURCE_BOOKING_FLAG(EVT.EVENT_ID)
, 1
, 1)) RESOURCE_BOOKINGS
, ORGT1.NAME TRAINING_CENTER
, VEN.VENDOR_NAME SUPPLIER_NAME
, EVT.ENROLMENT_START_DATE ENROLLMENT_START_DATE
, EVT.ENROLMENT_END_DATE ENROLLMENT_END_DATE
, LNG.DESCRIPTION LANGUAGE
, DECODE(EVT.EVENT_STATUS
, NULL
, NULL
, HR_BIS.BIS_DECODE_LOOKUP('SCHEDULED_EVENT_STATUS'
, EVT.EVENT_STATUS)) EVENT_STATUS
, DECODE(EVT.USER_STATUS
, NULL
, NULL
, HR_BIS.BIS_DECODE_LOOKUP('EVENT_USER_STATUS'
, EVT.USER_STATUS)) EVENT_USER_STATUS
, EVT.MINIMUM_ATTENDEES MINIMUM_ATTENDEES
, EVT.MAXIMUM_ATTENDEES MAXIMUM_ATTENDEES
, EVT.STANDARD_PRICE STANDARD_PRICE
, CUR.NAME CURRENCY
, ORGT.NAME ORGANIZATION_NAME
, JOB.NAME JOB_NAME
, POS.NAME POSITION_NAME
, TEA.COMMENTS EVENT_ASSOCIATION_COMMENTS
, EVT.TIMEZONE TIME_ZONE
, '_DF:OTA:OTA_EVENTS:EVT'
, '_DF:OTA:OTA_EVENT_ASSOCIATIONS:TEA'
, EVT.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, EVT.EVENT_ID EVENT_ID
, TEA.ORGANIZATION_ID ORGANIZATION_ID
, TEA.JOB_ID JOB_ID
, TEA.POSITION_ID POSITION_ID
, TEA.EVENT_ASSOCIATION_ID EVENT_ASSOCIATION_ID
, EVT.TRAINING_CENTER_ID TRAINING_CENTER_ID
, EVT.OFFERING_ID OFFERING_ID
FROM HR_ALL_ORGANIZATION_UNITS_TL BGRT
, OTA_EVENTS EVT
, HR_ALL_ORGANIZATION_UNITS_TL ORGT
, PER_ALL_POSITIONS POS
, PER_JOBS JOB
, OTA_EVENT_ASSOCIATIONS TEA
, PO_VENDORS VEN
, FND_CURRENCIES_VL CUR
, FND_LANGUAGES_VL LNG
, HR_ALL_ORGANIZATION_UNITS_TL ORGT1
WHERE EVT.PUBLIC_EVENT_FLAG = 'N'
AND EVT.TRAINING_CENTER_ID = ORGT1.ORGANIZATION_ID (+)
AND DECODE(ORGT1.LANGUAGE
, NULL
, 'X'
, ORGT1.LANGUAGE)= DECODE(ORGT1.LANGUAGE
, NULL
, 'X'
, USERENV('LANG'))
AND EVT.EVENT_ID = TEA.EVENT_ID
AND EVT.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND TEA.ORGANIZATION_ID = ORGT.ORGANIZATION_ID (+)
AND TEA.CUSTOMER_ID IS NULL
AND DECODE(ORGT.ORGANIZATION_ID
, NULL
, 'X'
, ORGT.LANGUAGE) = DECODE(ORGT.ORGANIZATION_ID
, NULL
, 'X'
, USERENV('LANG'))
AND TEA.JOB_ID = JOB.JOB_ID (+)
AND TEA.POSITION_ID = POS.POSITION_ID (+)
AND EVT.VENDOR_ID = VEN.VENDOR_ID (+)
AND EVT.CURRENCY_CODE = CUR.CURRENCY_CODE (+)
AND EVT.LANGUAGE_ID = LNG.LANGUAGE_ID (+)
AND EVT.BUSINESS_GROUP_ID = NVL(OTA_GENERAL.GET_BUSINESS_GROUP_ID
, EVT.BUSINESS_GROUP_ID) WITH READ ONLY

Columns