Product: | OTA - Learning Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.OTA_TRAINING_PLANS_V |
SELECT TPS.ROWID
, TPS.TRAINING_PLAN_ID
, DECODE(TPS.ORGANIZATION_ID
, NULL
, 'PERSON'
, 'ORGANIZATION')
, TPS.TIME_PERIOD_ID
, CAL.PERIOD_SET_NAME
, PTP.PERIOD_NAME
, PTP.START_DATE
, PTP.END_DATE
, TPS.PLAN_STATUS_TYPE_ID
, LKP.MEANING
, TPS.ORGANIZATION_ID
, ORG.NAME
, TPS.PERSON_ID
, PEO.FULL_NAME
, PEO.EMPLOYEE_NUMBER
, TPS.BUDGET_CURRENCY
, TPS.NAME
, TPS.DESCRIPTION
, TPS.BUSINESS_GROUP_ID
, TPS.OBJECT_VERSION_NUMBER
, TPS.ATTRIBUTE_CATEGORY
, TPS.ATTRIBUTE1
, TPS.ATTRIBUTE2
, TPS.ATTRIBUTE3
, TPS.ATTRIBUTE4
, TPS.ATTRIBUTE5
, TPS.ATTRIBUTE6
, TPS.ATTRIBUTE7
, TPS.ATTRIBUTE8
, TPS.ATTRIBUTE9
, TPS.ATTRIBUTE10
, TPS.ATTRIBUTE11
, TPS.ATTRIBUTE12
, TPS.ATTRIBUTE13
, TPS.ATTRIBUTE14
, TPS.ATTRIBUTE15
, TPS.ATTRIBUTE16
, TPS.ATTRIBUTE17
, TPS.ATTRIBUTE18
, TPS.ATTRIBUTE19
, TPS.ATTRIBUTE20
, TPS.ATTRIBUTE21
, TPS.ATTRIBUTE22
, TPS.ATTRIBUTE23
, TPS.ATTRIBUTE24
, TPS.ATTRIBUTE25
, TPS.ATTRIBUTE26
, TPS.ATTRIBUTE27
, TPS.ATTRIBUTE28
, TPS.ATTRIBUTE29
, TPS.ATTRIBUTE30
, TPS.CREATED_BY
, TPS.CREATION_DATE
, TPS.LAST_UPDATED_BY
, TPS.LAST_UPDATE_DATE
, TPS.LAST_UPDATE_LOGIN
FROM FND_SESSIONS SES
, PER_ALL_PEOPLE_F PEO
, PAY_CALENDARS CAL
, PER_TIME_PERIODS PTP
, HR_LOOKUPS LKP
, HR_ALL_ORGANIZATION_UNITS ORG
, OTA_TRAINING_PLANS TPS
WHERE TPS.PLAN_STATUS_TYPE_ID = LKP.LOOKUP_CODE AND LKP.LOOKUP_TYPE = 'OTA_PLAN_USER_STATUS_TYPE' AND TPS.TIME_PERIOD_ID = PTP.TIME_PERIOD_ID AND PTP.PERIOD_SET_NAME = CAL.PERIOD_SET_NAME
AND TPS.ORGANIZATION_ID = ORG.ORGANIZATION_ID(+) AND SES.SESSION_ID = USERENV('SESSIONID') AND TPS.PERSON_ID = PEO.PERSON_ID(+) AND SES.EFFECTIVE_DATE >= NVL(PEO.EFFECTIVE_START_DATE
, SES.EFFECTIVE_DATE)
AND SES.EFFECTIVE_DATE <= NVL(PEO.EFFECTIVE_END_DATE
, SES.EFFECTIVE_DATE)