Product: | OTA - Learning Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.OTA_TP_MEASUREMENT_TYPES_V |
SELECT TMT.ROWID
, TMT.TP_MEASUREMENT_TYPE_ID
, TMT.TP_MEASUREMENT_CODE
, MTY.MEANING
, TMT.UNIT
, UNT.MEANING
, TMT.REPORTING_SEQUENCE
, TMT.BUDGET_LEVEL
, TMT.COST_LEVEL
, TMT.MANY_BUDGET_VALUES_FLAG
, TMT.ITEM_TYPE_USAGE_ID
, TEM.NAME
, TEM.TEMPLATE_ID
, ITY.TITLE
, ITU.SEQUENCE_NUMBER
, TMT.BUSINESS_GROUP_ID
, TMT.OBJECT_VERSION_NUMBER
, TMT.ATTRIBUTE_CATEGORY
, TMT.ATTRIBUTE1
, TMT.ATTRIBUTE2
, TMT.ATTRIBUTE3
, TMT.ATTRIBUTE4
, TMT.ATTRIBUTE5
, TMT.ATTRIBUTE6
, TMT.ATTRIBUTE7
, TMT.ATTRIBUTE8
, TMT.ATTRIBUTE9
, TMT.ATTRIBUTE10
, TMT.ATTRIBUTE11
, TMT.ATTRIBUTE12
, TMT.ATTRIBUTE13
, TMT.ATTRIBUTE14
, TMT.ATTRIBUTE15
, TMT.ATTRIBUTE16
, TMT.ATTRIBUTE17
, TMT.ATTRIBUTE18
, TMT.ATTRIBUTE19
, TMT.ATTRIBUTE20
, TMT.ATTRIBUTE21
, TMT.ATTRIBUTE22
, TMT.ATTRIBUTE23
, TMT.ATTRIBUTE24
, TMT.ATTRIBUTE25
, TMT.ATTRIBUTE26
, TMT.ATTRIBUTE27
, TMT.ATTRIBUTE28
, TMT.ATTRIBUTE29
, TMT.ATTRIBUTE30
, TMT.CREATED_BY
, TMT.CREATION_DATE
, TMT.LAST_UPDATED_BY
, TMT.LAST_UPDATE_DATE
, TMT.LAST_UPDATE_LOGIN
FROM HR_SUMMARY_ITEM_TYPE ITY
, HR_SUMMARY_TEMPLATE TEM
, HR_SUMMARY_ITEM_TYPE_USAGE ITU
, HR_LOOKUPS UNT
, HR_LOOKUPS MTY
, OTA_TP_MEASUREMENT_TYPES TMT
WHERE TMT.TP_MEASUREMENT_CODE = MTY.LOOKUP_CODE AND MTY.LOOKUP_TYPE = 'OTA_PLAN_MEASUREMENT_TYPE' AND TMT.UNIT = UNT.LOOKUP_CODE AND UNT.LOOKUP_TYPE = 'UNITS'
AND TMT.ITEM_TYPE_USAGE_ID = ITU.ITEM_TYPE_USAGE_ID(+) AND ITU.TEMPLATE_ID = TEM.TEMPLATE_ID(+) AND ITU.ITEM_TYPE_ID = ITY.ITEM_TYPE_ID(+)