View: OTV_ACTIVITIES

Product:	OTA - Learning Management
Description:	View to list all information about an Activity and Activity Version.
Implementation/DBA Data:	APPS.OTV_ACTIVITIES

View Text

SELECT OAV.VERSION_NAME
, OAV.DESCRIPTION
, OAD.NAME
, LNG.DESCRIPTION
, OAV.DURATION
, HR_GENERAL.DECODE_LOOKUP('FREQUENCY'
, OAV.DURATION_UNITS)
, HR_GENERAL.DECODE_LOOKUP('ACTIVITY_USER_STATUS'
, OAV.USER_STATUS)
, OAV.OBJECTIVES
, OAV.INTENDED_AUDIENCE
, PEO.FULL_NAME
, VEN.VENDOR_NAME
, OAV.CONTROLLING_PERSON_ID
, OAV.ACTIVITY_ID
, OAV.ACTIVITY_VERSION_ID
, OAD.BUSINESS_GROUP_ID
, BGR.NAME
FROM OTA_ACTIVITY_VERSIONS OAV
, OTA_ACTIVITY_DEFINITIONS OAD
, FND_LANGUAGES_VL LNG
, PER_PEOPLE_F PEO
, PO_VENDORS VEN
, HR_ALL_ORGANIZATION_UNITS BGR
WHERE OAV.LANGUAGE_ID = LNG.LANGUAGE_ID(+)
AND OAV.ACTIVITY_ID = OAD.ACTIVITY_ID
AND OAV.CONTROLLING_PERSON_ID = PEO.PERSON_ID(+)
AND TRUNC(SYSDATE) BETWEEN NVL(OAV.START_DATE
, TRUNC(SYSDATE))
AND NVL(OAV.END_DATE
, TRUNC(SYSDATE))
AND OAV.START_DATE BETWEEN PEO.EFFECTIVE_START_DATE(+)
AND PEO.EFFECTIVE_END_DATE(+)
AND OAV.VENDOR_ID = VEN.VENDOR_ID(+)
AND EXISTS ( SELECT NULL
FROM OTV_SCHEDULED_EVENTS OSE
WHERE OSE.ACTIVITY_VERSION_ID = OAV.ACTIVITY_VERSION_ID)
AND OAD.BUSINESS_GROUP_ID =BGR.ORGANIZATION_ID
AND OAD.BUSINESS_GROUP_ID =NVL(OTA_GENERAL.GET_BUSINESS_GROUP_ID
, OAD.BUSINESS_GROUP_ID)

Columns