VIEW: APPS.OTA_TRAINING_PLAN_BUDGETS_V

Source

View Text - Preformatted

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 ,FND_LOOKUP_VALUES LU1 ,FND_LOOKUP_VALUES LU2 WHERE LU1.LANGUAGE = USERENV('LANG') AND LU1.VIEW_APPLICATION_ID = 3 AND LU2.LANGUAGE = USERENV('LANG') AND LU2.VIEW_APPLICATION_ID = 3 AND 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 ,FND_LOOKUP_VALUES LU1 ,FND_LOOKUP_VALUES LU2 ,OTA_TP_MEASUREMENT_TYPES TMT ,OTA_TRAINING_PLAN_MEMBERS TPM ,OTA_ACTIVITY_VERSIONS OAV WHERE LU1.LANGUAGE = USERENV('LANG') AND LU1.VIEW_APPLICATION_ID = 3 AND LU2.LANGUAGE = USERENV('LANG') AND LU2.VIEW_APPLICATION_ID = 3 AND 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 ,FND_LOOKUP_VALUES LU1 ,FND_LOOKUP_VALUES LU2 ,OTA_TP_MEASUREMENT_TYPES TMT ,OTA_TRAINING_PLAN_MEMBERS TPM ,OTA_ACTIVITY_DEFINITIONS OAD WHERE LU1.LANGUAGE = USERENV('LANG') AND LU1.VIEW_APPLICATION_ID = 3 AND LU2.LANGUAGE = USERENV('LANG') AND LU2.VIEW_APPLICATION_ID = 3 AND 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 ,FND_LOOKUP_VALUES LU1 ,FND_LOOKUP_VALUES LU2 ,OTA_TRAINING_PLAN_MEMBERS TPM ,OTA_ACTIVITY_VERSIONS OAV ,OTA_EVENTS OAE WHERE LU1.LANGUAGE = USERENV('LANG') AND LU1.VIEW_APPLICATION_ID = 3 AND LU2.LANGUAGE = USERENV('LANG') AND LU2.VIEW_APPLICATION_ID = 3 AND 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 ,FND_LOOKUP_VALUES LU1 ,FND_LOOKUP_VALUES LU2 ,OTA_TRAINING_PLAN_MEMBERS TPM ,OTA_ACTIVITY_DEFINITIONS OAD ,OTA_EVENTS OAE WHERE LU1.LANGUAGE = USERENV('LANG') AND LU1.VIEW_APPLICATION_ID = 3 AND LU2.LANGUAGE = USERENV('LANG') AND LU2.VIEW_APPLICATION_ID = 3 AND 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

View Text - HTML Formatted

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
, FND_LOOKUP_VALUES LU1
, FND_LOOKUP_VALUES LU2
WHERE LU1.LANGUAGE = USERENV('LANG')
AND LU1.VIEW_APPLICATION_ID = 3
AND LU2.LANGUAGE = USERENV('LANG')
AND LU2.VIEW_APPLICATION_ID = 3
AND 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
, FND_LOOKUP_VALUES LU1
, FND_LOOKUP_VALUES LU2
, OTA_TP_MEASUREMENT_TYPES TMT
, OTA_TRAINING_PLAN_MEMBERS TPM
, OTA_ACTIVITY_VERSIONS OAV
WHERE LU1.LANGUAGE = USERENV('LANG')
AND LU1.VIEW_APPLICATION_ID = 3
AND LU2.LANGUAGE = USERENV('LANG')
AND LU2.VIEW_APPLICATION_ID = 3
AND 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
, FND_LOOKUP_VALUES LU1
, FND_LOOKUP_VALUES LU2
, OTA_TP_MEASUREMENT_TYPES TMT
, OTA_TRAINING_PLAN_MEMBERS TPM
, OTA_ACTIVITY_DEFINITIONS OAD
WHERE LU1.LANGUAGE = USERENV('LANG')
AND LU1.VIEW_APPLICATION_ID = 3
AND LU2.LANGUAGE = USERENV('LANG')
AND LU2.VIEW_APPLICATION_ID = 3
AND 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
, FND_LOOKUP_VALUES LU1
, FND_LOOKUP_VALUES LU2
, OTA_TRAINING_PLAN_MEMBERS TPM
, OTA_ACTIVITY_VERSIONS OAV
, OTA_EVENTS OAE
WHERE LU1.LANGUAGE = USERENV('LANG')
AND LU1.VIEW_APPLICATION_ID = 3
AND LU2.LANGUAGE = USERENV('LANG')
AND LU2.VIEW_APPLICATION_ID = 3
AND 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
, FND_LOOKUP_VALUES LU1
, FND_LOOKUP_VALUES LU2
, OTA_TRAINING_PLAN_MEMBERS TPM
, OTA_ACTIVITY_DEFINITIONS OAD
, OTA_EVENTS OAE
WHERE LU1.LANGUAGE = USERENV('LANG')
AND LU1.VIEW_APPLICATION_ID = 3
AND LU2.LANGUAGE = USERENV('LANG')
AND LU2.VIEW_APPLICATION_ID = 3
AND 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