Product: | OTA - Learning Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.OTA_TRAINING_PLAN_BUDGETS_V |
SELECT PBV.ROWID
, PBE.TRAINING_PLAN_ID
, PB.UNIT
, LU1.MEANING
, TMT.UNIT
, LU2.MEANING
, TMT.BUDGET_LEVEL
, TMT.MANY_BUDGET_VALUES_FLAG
, PB.BUDGET_ID
, PB.PERIOD_SET_NAME
, PB.BUSINESS_GROUP_ID
, PBR.BUDGET_VERSION_ID
, PBE.BUDGET_ELEMENT_ID
, PBV.BUDGET_VALUE_ID
, PBV.VALUE
, 'PLAN_BUDGET'
, 'NONE'
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, TO_DATE(NULL)
, TO_DATE(NULL)
, PBV.INFORMATION_CATEGORY
, PBV.BUDGET_INFORMATION1
, PBV.BUDGET_INFORMATION2
, PBV.BUDGET_INFORMATION3
, PBV.BUDGET_INFORMATION4
, PBV.BUDGET_INFORMATION5
, PBV.BUDGET_INFORMATION6
, PBV.BUDGET_INFORMATION7
, PBV.BUDGET_INFORMATION8
, PBV.BUDGET_INFORMATION9
, PBV.BUDGET_INFORMATION10
, PBV.BUDGET_INFORMATION11
, PBV.BUDGET_INFORMATION12
, PBV.BUDGET_INFORMATION13
, PBV.BUDGET_INFORMATION14
, PBV.BUDGET_INFORMATION15
, PBV.BUDGET_INFORMATION16
, PBV.BUDGET_INFORMATION17
, PBV.BUDGET_INFORMATION18
, PBV.BUDGET_INFORMATION19
, PBV.BUDGET_INFORMATION20
, PBV.BUDGET_INFORMATION21
, PBV.BUDGET_INFORMATION22
, PBV.BUDGET_INFORMATION23
, PBV.BUDGET_INFORMATION24
, PBV.BUDGET_INFORMATION25
, PBV.BUDGET_INFORMATION26
, PBV.BUDGET_INFORMATION27
, PBV.BUDGET_INFORMATION28
, PBV.BUDGET_INFORMATION29
, PBV.BUDGET_INFORMATION30
, PBV.ATTRIBUTE_CATEGORY
, PBV.ATTRIBUTE1
, PBV.ATTRIBUTE2
, PBV.ATTRIBUTE3
, PBV.ATTRIBUTE4
, PBV.ATTRIBUTE5
, PBV.ATTRIBUTE6
, PBV.ATTRIBUTE7
, PBV.ATTRIBUTE8
, PBV.ATTRIBUTE9
, PBV.ATTRIBUTE10
, PBV.ATTRIBUTE11
, PBV.ATTRIBUTE12
, PBV.ATTRIBUTE13
, PBV.ATTRIBUTE14
, PBV.ATTRIBUTE15
, PBV.ATTRIBUTE16
, PBV.ATTRIBUTE17
, PBV.ATTRIBUTE18
, PBV.ATTRIBUTE19
, PBV.ATTRIBUTE20
, PBV.ATTRIBUTE21
, PBV.ATTRIBUTE22
, PBV.ATTRIBUTE23
, PBV.ATTRIBUTE24
, PBV.ATTRIBUTE25
, PBV.ATTRIBUTE26
, PBV.ATTRIBUTE27
, PBV.ATTRIBUTE28
, PBV.ATTRIBUTE29
, PBV.ATTRIBUTE30
, PBV.CREATED_BY
, PBV.CREATION_DATE
, PBV.LAST_UPDATED_BY
, PBV.LAST_UPDATE_DATE
, PBV.LAST_UPDATE_LOGIN
FROM PER_BUDGETS PB
, PER_BUDGET_VERSIONS PBR
, PER_BUDGET_ELEMENTS PBE
, PER_BUDGET_VALUES PBV
, OTA_TP_MEASUREMENT_TYPES TMT
, HR_LOOKUPS LU1
, HR_LOOKUPS LU2
WHERE PB.BUDGET_ID = PBR.BUDGET_ID
AND PBR.BUDGET_VERSION_ID = PBE.BUDGET_VERSION_ID
AND PBE.BUDGET_ELEMENT_ID = PBV.BUDGET_ELEMENT_ID
AND PB.BUDGET_TYPE_CODE = 'OTA_BUDGET'
AND LU1.LOOKUP_TYPE = 'OTA_PLAN_MEASUREMENT_TYPE'
AND LU1.LOOKUP_CODE = PB.UNIT
AND LU2.LOOKUP_TYPE = 'UNITS'
AND LU2.LOOKUP_CODE = TMT.UNIT
AND TMT.BUSINESS_GROUP_ID = PB.BUSINESS_GROUP_ID
AND PB.UNIT = TMT.TP_MEASUREMENT_CODE
AND PBE.TRAINING_PLAN_MEMBER_ID IS NULL
AND PBE.EVENT_ID IS NULL UNION SELECT PBV.ROWID
, PBE.TRAINING_PLAN_ID
, PB.UNIT
, LU1.MEANING
, TMT.UNIT
, LU2.MEANING
, TMT.BUDGET_LEVEL
, TMT.MANY_BUDGET_VALUES_FLAG
, PB.BUDGET_ID
, PB.PERIOD_SET_NAME
, PB.BUSINESS_GROUP_ID
, PBR.BUDGET_VERSION_ID
, PBE.BUDGET_ELEMENT_ID
, PBV.BUDGET_VALUE_ID
, PBV.VALUE
, 'ACTIVITY'
, 'ACTIVITY_VERSION'
, PBE.TRAINING_PLAN_MEMBER_ID
, OAV.VERSION_NAME
, TO_NUMBER(NULL)
, TPM.ACTIVITY_VERSION_ID
, TO_NUMBER(NULL)
, NULL
, TO_DATE(NULL)
, TO_DATE(NULL)
, PBV.INFORMATION_CATEGORY
, PBV.BUDGET_INFORMATION1
, PBV.BUDGET_INFORMATION2
, PBV.BUDGET_INFORMATION3
, PBV.BUDGET_INFORMATION4
, PBV.BUDGET_INFORMATION5
, PBV.BUDGET_INFORMATION6
, PBV.BUDGET_INFORMATION7
, PBV.BUDGET_INFORMATION8
, PBV.BUDGET_INFORMATION9
, PBV.BUDGET_INFORMATION10
, PBV.BUDGET_INFORMATION11
, PBV.BUDGET_INFORMATION12
, PBV.BUDGET_INFORMATION13
, PBV.BUDGET_INFORMATION14
, PBV.BUDGET_INFORMATION15
, PBV.BUDGET_INFORMATION16
, PBV.BUDGET_INFORMATION17
, PBV.BUDGET_INFORMATION18
, PBV.BUDGET_INFORMATION19
, PBV.BUDGET_INFORMATION20
, PBV.BUDGET_INFORMATION21
, PBV.BUDGET_INFORMATION22
, PBV.BUDGET_INFORMATION23
, PBV.BUDGET_INFORMATION24
, PBV.BUDGET_INFORMATION25
, PBV.BUDGET_INFORMATION26
, PBV.BUDGET_INFORMATION27
, PBV.BUDGET_INFORMATION28
, PBV.BUDGET_INFORMATION29
, PBV.BUDGET_INFORMATION30
, PBV.ATTRIBUTE_CATEGORY
, PBV.ATTRIBUTE1
, PBV.ATTRIBUTE2
, PBV.ATTRIBUTE3
, PBV.ATTRIBUTE4
, PBV.ATTRIBUTE5
, PBV.ATTRIBUTE6
, PBV.ATTRIBUTE7
, PBV.ATTRIBUTE8
, PBV.ATTRIBUTE9
, PBV.ATTRIBUTE10
, PBV.ATTRIBUTE11
, PBV.ATTRIBUTE12
, PBV.ATTRIBUTE13
, PBV.ATTRIBUTE14
, PBV.ATTRIBUTE15
, PBV.ATTRIBUTE16
, PBV.ATTRIBUTE17
, PBV.ATTRIBUTE18
, PBV.ATTRIBUTE19
, PBV.ATTRIBUTE20
, PBV.ATTRIBUTE21
, PBV.ATTRIBUTE22
, PBV.ATTRIBUTE23
, PBV.ATTRIBUTE24
, PBV.ATTRIBUTE25
, PBV.ATTRIBUTE26
, PBV.ATTRIBUTE27
, PBV.ATTRIBUTE28
, PBV.ATTRIBUTE29
, PBV.ATTRIBUTE30
, PBV.CREATED_BY
, PBV.CREATION_DATE
, PBV.LAST_UPDATED_BY
, PBV.LAST_UPDATE_DATE
, PBV.LAST_UPDATE_LOGIN
FROM PER_BUDGETS PB
, PER_BUDGET_VERSIONS PBR
, PER_BUDGET_ELEMENTS PBE
, PER_BUDGET_VALUES PBV
, HR_LOOKUPS LU1
, HR_LOOKUPS LU2
, OTA_TP_MEASUREMENT_TYPES TMT
, OTA_TRAINING_PLAN_MEMBERS TPM
, OTA_ACTIVITY_VERSIONS OAV
WHERE PB.BUDGET_ID = PBR.BUDGET_ID
AND PBR.BUDGET_VERSION_ID = PBE.BUDGET_VERSION_ID
AND PBE.BUDGET_ELEMENT_ID = PBV.BUDGET_ELEMENT_ID
AND PB.BUDGET_TYPE_CODE = 'OTA_BUDGET'
AND LU1.LOOKUP_TYPE = 'OTA_PLAN_MEASUREMENT_TYPE'
AND LU1.LOOKUP_CODE = PB.UNIT
AND LU2.LOOKUP_TYPE = 'UNITS'
AND LU2.LOOKUP_CODE = TMT.UNIT
AND TMT.BUSINESS_GROUP_ID = PB.BUSINESS_GROUP_ID
AND PB.UNIT = TMT.TP_MEASUREMENT_CODE
AND PBE.TRAINING_PLAN_MEMBER_ID = TPM.TRAINING_PLAN_MEMBER_ID
AND TPM.ACTIVITY_VERSION_ID = OAV.ACTIVITY_VERSION_ID
AND TPM.ACTIVITY_VERSION_ID IS NOT NULL
AND PBE.EVENT_ID IS NULL UNION SELECT PBV.ROWID
, PBE.TRAINING_PLAN_ID
, PB.UNIT
, LU1.MEANING
, TMT.UNIT
, LU2.MEANING
, TMT.BUDGET_LEVEL
, TMT.MANY_BUDGET_VALUES_FLAG
, PB.BUDGET_ID
, PB.PERIOD_SET_NAME
, PB.BUSINESS_GROUP_ID
, PBR.BUDGET_VERSION_ID
, PBE.BUDGET_ELEMENT_ID
, PBV.BUDGET_VALUE_ID
, PBV.VALUE
, 'ACTIVITY'
, 'ACTIVITY_DEFINITION'
, PBE.TRAINING_PLAN_MEMBER_ID
, OAD.NAME
, TPM.ACTIVITY_DEFINITION_ID
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, TO_DATE(NULL)
, TO_DATE(NULL)
, PBV.INFORMATION_CATEGORY
, PBV.BUDGET_INFORMATION1
, PBV.BUDGET_INFORMATION2
, PBV.BUDGET_INFORMATION3
, PBV.BUDGET_INFORMATION4
, PBV.BUDGET_INFORMATION5
, PBV.BUDGET_INFORMATION6
, PBV.BUDGET_INFORMATION7
, PBV.BUDGET_INFORMATION8
, PBV.BUDGET_INFORMATION9
, PBV.BUDGET_INFORMATION10
, PBV.BUDGET_INFORMATION11
, PBV.BUDGET_INFORMATION12
, PBV.BUDGET_INFORMATION13
, PBV.BUDGET_INFORMATION14
, PBV.BUDGET_INFORMATION15
, PBV.BUDGET_INFORMATION16
, PBV.BUDGET_INFORMATION17
, PBV.BUDGET_INFORMATION18
, PBV.BUDGET_INFORMATION19
, PBV.BUDGET_INFORMATION20
, PBV.BUDGET_INFORMATION21
, PBV.BUDGET_INFORMATION22
, PBV.BUDGET_INFORMATION23
, PBV.BUDGET_INFORMATION24
, PBV.BUDGET_INFORMATION25
, PBV.BUDGET_INFORMATION26
, PBV.BUDGET_INFORMATION27
, PBV.BUDGET_INFORMATION28
, PBV.BUDGET_INFORMATION29
, PBV.BUDGET_INFORMATION30
, PBV.ATTRIBUTE_CATEGORY
, PBV.ATTRIBUTE1
, PBV.ATTRIBUTE2
, PBV.ATTRIBUTE3
, PBV.ATTRIBUTE4
, PBV.ATTRIBUTE5
, PBV.ATTRIBUTE6
, PBV.ATTRIBUTE7
, PBV.ATTRIBUTE8
, PBV.ATTRIBUTE9
, PBV.ATTRIBUTE10
, PBV.ATTRIBUTE11
, PBV.ATTRIBUTE12
, PBV.ATTRIBUTE13
, PBV.ATTRIBUTE14
, PBV.ATTRIBUTE15
, PBV.ATTRIBUTE16
, PBV.ATTRIBUTE17
, PBV.ATTRIBUTE18
, PBV.ATTRIBUTE19
, PBV.ATTRIBUTE20
, PBV.ATTRIBUTE21
, PBV.ATTRIBUTE22
, PBV.ATTRIBUTE23
, PBV.ATTRIBUTE24
, PBV.ATTRIBUTE25
, PBV.ATTRIBUTE26
, PBV.ATTRIBUTE27
, PBV.ATTRIBUTE28
, PBV.ATTRIBUTE29
, PBV.ATTRIBUTE30
, PBV.CREATED_BY
, PBV.CREATION_DATE
, PBV.LAST_UPDATED_BY
, PBV.LAST_UPDATE_DATE
, PBV.LAST_UPDATE_LOGIN
FROM PER_BUDGETS PB
, PER_BUDGET_VERSIONS PBR
, PER_BUDGET_ELEMENTS PBE
, PER_BUDGET_VALUES PBV
, HR_LOOKUPS LU1
, HR_LOOKUPS LU2
, OTA_TP_MEASUREMENT_TYPES TMT
, OTA_TRAINING_PLAN_MEMBERS TPM
, OTA_ACTIVITY_DEFINITIONS OAD
WHERE PB.BUDGET_ID = PBR.BUDGET_ID
AND PBR.BUDGET_VERSION_ID = PBE.BUDGET_VERSION_ID
AND PBE.BUDGET_ELEMENT_ID = PBV.BUDGET_ELEMENT_ID
AND PB.BUDGET_TYPE_CODE = 'OTA_BUDGET'
AND LU1.LOOKUP_TYPE = 'OTA_PLAN_MEASUREMENT_TYPE'
AND LU1.LOOKUP_CODE = PB.UNIT
AND LU2.LOOKUP_TYPE = 'UNITS'
AND LU2.LOOKUP_CODE = TMT.UNIT
AND TMT.BUSINESS_GROUP_ID = PB.BUSINESS_GROUP_ID
AND PB.UNIT = TMT.TP_MEASUREMENT_CODE
AND PBE.TRAINING_PLAN_MEMBER_ID = TPM.TRAINING_PLAN_MEMBER_ID
AND TPM.ACTIVITY_DEFINITION_ID = OAD.ACTIVITY_ID
AND TPM.ACTIVITY_DEFINITION_ID IS NOT NULL
AND PBE.EVENT_ID IS NULL UNION SELECT PBV.ROWID
, PBE.TRAINING_PLAN_ID
, PB.UNIT
, LU1.MEANING
, TMT.UNIT
, LU2.MEANING
, TMT.BUDGET_LEVEL
, TMT.MANY_BUDGET_VALUES_FLAG
, PB.BUDGET_ID
, PB.PERIOD_SET_NAME
, PB.BUSINESS_GROUP_ID
, PBR.BUDGET_VERSION_ID
, PBE.BUDGET_ELEMENT_ID
, PBV.BUDGET_VALUE_ID
, PBV.VALUE
, 'EVENT'
, 'ACTIVITY_VERSION'
, PBE.TRAINING_PLAN_MEMBER_ID
, OAV.VERSION_NAME
, TO_NUMBER(NULL)
, TPM.ACTIVITY_VERSION_ID
, OAE.EVENT_ID
, OAE.TITLE
, OAE.COURSE_START_DATE
, OAE.COURSE_END_DATE
, PBV.INFORMATION_CATEGORY
, PBV.BUDGET_INFORMATION1
, PBV.BUDGET_INFORMATION2
, PBV.BUDGET_INFORMATION3
, PBV.BUDGET_INFORMATION4
, PBV.BUDGET_INFORMATION5
, PBV.BUDGET_INFORMATION6
, PBV.BUDGET_INFORMATION7
, PBV.BUDGET_INFORMATION8
, PBV.BUDGET_INFORMATION9
, PBV.BUDGET_INFORMATION10
, PBV.BUDGET_INFORMATION11
, PBV.BUDGET_INFORMATION12
, PBV.BUDGET_INFORMATION13
, PBV.BUDGET_INFORMATION14
, PBV.BUDGET_INFORMATION15
, PBV.BUDGET_INFORMATION16
, PBV.BUDGET_INFORMATION17
, PBV.BUDGET_INFORMATION18
, PBV.BUDGET_INFORMATION19
, PBV.BUDGET_INFORMATION20
, PBV.BUDGET_INFORMATION21
, PBV.BUDGET_INFORMATION22
, PBV.BUDGET_INFORMATION23
, PBV.BUDGET_INFORMATION24
, PBV.BUDGET_INFORMATION25
, PBV.BUDGET_INFORMATION26
, PBV.BUDGET_INFORMATION27
, PBV.BUDGET_INFORMATION28
, PBV.BUDGET_INFORMATION29
, PBV.BUDGET_INFORMATION30
, PBV.ATTRIBUTE_CATEGORY
, PBV.ATTRIBUTE1
, PBV.ATTRIBUTE2
, PBV.ATTRIBUTE3
, PBV.ATTRIBUTE4
, PBV.ATTRIBUTE5
, PBV.ATTRIBUTE6
, PBV.ATTRIBUTE7
, PBV.ATTRIBUTE8
, PBV.ATTRIBUTE9
, PBV.ATTRIBUTE10
, PBV.ATTRIBUTE11
, PBV.ATTRIBUTE12
, PBV.ATTRIBUTE13
, PBV.ATTRIBUTE14
, PBV.ATTRIBUTE15
, PBV.ATTRIBUTE16
, PBV.ATTRIBUTE17
, PBV.ATTRIBUTE18
, PBV.ATTRIBUTE19
, PBV.ATTRIBUTE20
, PBV.ATTRIBUTE21
, PBV.ATTRIBUTE22
, PBV.ATTRIBUTE23
, PBV.ATTRIBUTE24
, PBV.ATTRIBUTE25
, PBV.ATTRIBUTE26
, PBV.ATTRIBUTE27
, PBV.ATTRIBUTE28
, PBV.ATTRIBUTE29
, PBV.ATTRIBUTE30
, PBV.CREATED_BY
, PBV.CREATION_DATE
, PBV.LAST_UPDATED_BY
, PBV.LAST_UPDATE_DATE
, PBV.LAST_UPDATE_LOGIN
FROM PER_BUDGETS PB
, PER_BUDGET_VERSIONS PBR
, PER_BUDGET_ELEMENTS PBE
, PER_BUDGET_VALUES PBV
, OTA_TP_MEASUREMENT_TYPES TMT
, HR_LOOKUPS LU1
, HR_LOOKUPS LU2
, OTA_TRAINING_PLAN_MEMBERS TPM
, OTA_ACTIVITY_VERSIONS OAV
, OTA_EVENTS OAE
WHERE PB.BUDGET_ID = PBR.BUDGET_ID
AND PBR.BUDGET_VERSION_ID = PBE.BUDGET_VERSION_ID
AND PBE.BUDGET_ELEMENT_ID = PBV.BUDGET_ELEMENT_ID
AND PB.BUDGET_TYPE_CODE = 'OTA_BUDGET'
AND LU1.LOOKUP_TYPE = 'OTA_PLAN_MEASUREMENT_TYPE'
AND LU1.LOOKUP_CODE = PB.UNIT
AND LU2.LOOKUP_TYPE = 'UNITS'
AND LU2.LOOKUP_CODE = TMT.UNIT
AND TMT.BUSINESS_GROUP_ID = PB.BUSINESS_GROUP_ID
AND PB.UNIT = TMT.TP_MEASUREMENT_CODE
AND PBE.TRAINING_PLAN_MEMBER_ID = TPM.TRAINING_PLAN_MEMBER_ID
AND TPM.ACTIVITY_VERSION_ID = OAV.ACTIVITY_VERSION_ID
AND PBE.EVENT_ID = OAE.EVENT_ID
AND TPM.ACTIVITY_VERSION_ID IS NOT NULL UNION SELECT PBV.ROWID
, PBE.TRAINING_PLAN_ID
, PB.UNIT
, LU1.MEANING
, TMT.UNIT
, LU2.MEANING
, TMT.BUDGET_LEVEL
, TMT.MANY_BUDGET_VALUES_FLAG
, PB.BUDGET_ID
, PB.PERIOD_SET_NAME
, PB.BUSINESS_GROUP_ID
, PBR.BUDGET_VERSION_ID
, PBE.BUDGET_ELEMENT_ID
, PBV.BUDGET_VALUE_ID
, PBV.VALUE
, 'EVENT'
, 'ACTIVITY_DEFINITION'
, PBE.TRAINING_PLAN_MEMBER_ID
, OAD.NAME
, TPM.ACTIVITY_DEFINITION_ID
, TO_NUMBER(NULL)
, OAE.EVENT_ID
, OAE.TITLE
, OAE.COURSE_START_DATE
, OAE.COURSE_END_DATE
, PBV.INFORMATION_CATEGORY
, PBV.BUDGET_INFORMATION1
, PBV.BUDGET_INFORMATION2
, PBV.BUDGET_INFORMATION3
, PBV.BUDGET_INFORMATION4
, PBV.BUDGET_INFORMATION5
, PBV.BUDGET_INFORMATION6
, PBV.BUDGET_INFORMATION7
, PBV.BUDGET_INFORMATION8
, PBV.BUDGET_INFORMATION9
, PBV.BUDGET_INFORMATION10
, PBV.BUDGET_INFORMATION11
, PBV.BUDGET_INFORMATION12
, PBV.BUDGET_INFORMATION13
, PBV.BUDGET_INFORMATION14
, PBV.BUDGET_INFORMATION15
, PBV.BUDGET_INFORMATION16
, PBV.BUDGET_INFORMATION17
, PBV.BUDGET_INFORMATION18
, PBV.BUDGET_INFORMATION19
, PBV.BUDGET_INFORMATION20
, PBV.BUDGET_INFORMATION21
, PBV.BUDGET_INFORMATION22
, PBV.BUDGET_INFORMATION23
, PBV.BUDGET_INFORMATION24
, PBV.BUDGET_INFORMATION25
, PBV.BUDGET_INFORMATION26
, PBV.BUDGET_INFORMATION27
, PBV.BUDGET_INFORMATION28
, PBV.BUDGET_INFORMATION29
, PBV.BUDGET_INFORMATION30
, PBV.ATTRIBUTE_CATEGORY
, PBV.ATTRIBUTE1
, PBV.ATTRIBUTE2
, PBV.ATTRIBUTE3
, PBV.ATTRIBUTE4
, PBV.ATTRIBUTE5
, PBV.ATTRIBUTE6
, PBV.ATTRIBUTE7
, PBV.ATTRIBUTE8
, PBV.ATTRIBUTE9
, PBV.ATTRIBUTE10
, PBV.ATTRIBUTE11
, PBV.ATTRIBUTE12
, PBV.ATTRIBUTE13
, PBV.ATTRIBUTE14
, PBV.ATTRIBUTE15
, PBV.ATTRIBUTE16
, PBV.ATTRIBUTE17
, PBV.ATTRIBUTE18
, PBV.ATTRIBUTE19
, PBV.ATTRIBUTE20
, PBV.ATTRIBUTE21
, PBV.ATTRIBUTE22
, PBV.ATTRIBUTE23
, PBV.ATTRIBUTE24
, PBV.ATTRIBUTE25
, PBV.ATTRIBUTE26
, PBV.ATTRIBUTE27
, PBV.ATTRIBUTE28
, PBV.ATTRIBUTE29
, PBV.ATTRIBUTE30
, PBV.CREATED_BY
, PBV.CREATION_DATE
, PBV.LAST_UPDATED_BY
, PBV.LAST_UPDATE_DATE
, PBV.LAST_UPDATE_LOGIN
FROM PER_BUDGETS PB
, PER_BUDGET_VERSIONS PBR
, PER_BUDGET_ELEMENTS PBE
, PER_BUDGET_VALUES PBV
, OTA_TP_MEASUREMENT_TYPES TMT
, HR_LOOKUPS LU1
, HR_LOOKUPS LU2
, OTA_TRAINING_PLAN_MEMBERS TPM
, OTA_ACTIVITY_DEFINITIONS OAD
, OTA_EVENTS OAE
WHERE PB.BUDGET_ID = PBR.BUDGET_ID
AND PBR.BUDGET_VERSION_ID = PBE.BUDGET_VERSION_ID
AND PBE.BUDGET_ELEMENT_ID = PBV.BUDGET_ELEMENT_ID
AND PB.BUDGET_TYPE_CODE = 'OTA_BUDGET'
AND LU1.LOOKUP_TYPE = 'OTA_PLAN_MEASUREMENT_TYPE'
AND LU1.LOOKUP_CODE = PB.UNIT
AND LU2.LOOKUP_TYPE = 'UNITS'
AND LU2.LOOKUP_CODE = TMT.UNIT
AND TMT.BUSINESS_GROUP_ID = PB.BUSINESS_GROUP_ID
AND PB.UNIT = TMT.TP_MEASUREMENT_CODE
AND PBE.TRAINING_PLAN_MEMBER_ID = TPM.TRAINING_PLAN_MEMBER_ID
AND TPM.ACTIVITY_DEFINITION_ID = OAD.ACTIVITY_ID
AND PBE.EVENT_ID = OAE.EVENT_ID
AND TPM.ACTIVITY_DEFINITION_ID IS NOT NULL