Product: | AHL - Complex Maintenance Repair and Overhaul |
---|---|
Description: | View based on the views AHL_MR_INTERVALS,CS_COUNTERS, and MTL_UNITS_OF_MEASURE_VL |
Implementation/DBA Data: | APPS.AHL_MR_INTERVALS_V |
SELECT I.MR_INTERVAL_ID
, I.OBJECT_VERSION_NUMBER
, I.MR_EFFECTIVITY_ID
, I.COUNTER_ID
, C.NAME
, M.UNIT_OF_MEASURE
, I.INTERVAL_VALUE
, I.START_VALUE
, I.STOP_VALUE
, I.START_DATE
, I.STOP_DATE
, I.TOLERANCE_BEFORE
, I.TOLERANCE_AFTER
, I.RESET_VALUE
, I.ATTRIBUTE_CATEGORY
, I.ATTRIBUTE1
, I.ATTRIBUTE2
, I.ATTRIBUTE3
, I.ATTRIBUTE4
, I.ATTRIBUTE5
, I.ATTRIBUTE6
, I.ATTRIBUTE7
, I.ATTRIBUTE8
, I.ATTRIBUTE9
, I.ATTRIBUTE10
, I.ATTRIBUTE11
, I.ATTRIBUTE12
, I.ATTRIBUTE13
, I.ATTRIBUTE14
, I.ATTRIBUTE15
, I.APPLICATION_USG_CODE
FROM AHL_MR_INTERVALS_APP_V I
, CS_COUNTERS C
, MTL_UNITS_OF_MEASURE_VL M
WHERE I.COUNTER_ID = C.COUNTER_ID
AND C.UOM_CODE = M.UOM_CODE