VIEW: APPS.OTA_TP_MEASUREMENT_TYPES_V

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)