Product: | OTA - Learning Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.OTA_LEARNING_PATHS_VL |
SELECT OLP.ROWID
, OLP.LEARNING_PATH_ID
, OLP.BUSINESS_GROUP_ID
, OLT.NAME
, OLT.DESCRIPTION
, OLT.OBJECTIVES
, OLT.KEYWORDS
, OLT.PURPOSE
, OLP.DURATION
, OLP.DURATION_UNITS
, OLP.START_DATE_ACTIVE
, OLP.END_DATE_ACTIVE
, OLP.OBJECT_VERSION_NUMBER
, OLP.CREATED_BY
, OLP.CREATION_DATE
, OLP.LAST_UPDATE_DATE
, OLP.LAST_UPDATED_BY
, OLP.LAST_UPDATE_LOGIN
, OLP.ATTRIBUTE_CATEGORY
, OLP.ATTRIBUTE1
, OLP.ATTRIBUTE2
, OLP.ATTRIBUTE3
, OLP.ATTRIBUTE4
, OLP.ATTRIBUTE5
, OLP.ATTRIBUTE6
, OLP.ATTRIBUTE7
, OLP.ATTRIBUTE8
, OLP.ATTRIBUTE9
, OLP.ATTRIBUTE10
, OLP.ATTRIBUTE11
, OLP.ATTRIBUTE12
, OLP.ATTRIBUTE13
, OLP.ATTRIBUTE14
, OLP.ATTRIBUTE15
, OLP.ATTRIBUTE16
, OLP.ATTRIBUTE17
, OLP.ATTRIBUTE18
, OLP.ATTRIBUTE19
, OLP.ATTRIBUTE20
, OLP.PATH_SOURCE_CODE
, OLP.SOURCE_FUNCTION_CODE
, OLP.ASSIGNMENT_ID
, OLP.SOURCE_ID
, OLP.NOTIFY_DAYS_BEFORE_TARGET
, OLP.PERSON_ID
, OLP.CONTACT_ID
, OLP.DISPLAY_TO_LEARNER_FLAG
, OLP.PUBLIC_FLAG
, OLP.COMPETENCY_UPDATE_LEVEL
FROM OTA_LEARNING_PATHS OLP
, OTA_LEARNING_PATHS_TL OLT
WHERE OLP.LEARNING_PATH_ID= OLT.LEARNING_PATH_ID
AND OLT.LANGUAGE = USERENV('LANG')