Product: | AHL - Complex Maintenance Repair and Overhaul |
---|---|
Description: | |
Implementation/DBA Data: | APPS.AHL_MR_INTERVALS_APP_V |
SELECT C.MR_INTERVAL_ID
, C.OBJECT_VERSION_NUMBER
, C.LAST_UPDATE_DATE
, C.LAST_UPDATED_BY
, C.CREATION_DATE
, C.CREATED_BY
, C.LAST_UPDATE_LOGIN
, C.MR_EFFECTIVITY_ID
, C.COUNTER_ID
, C.INTERVAL_VALUE
, C.START_VALUE
, C.STOP_VALUE
, C.START_DATE
, C.STOP_DATE
, C.TOLERANCE_BEFORE
, C.TOLERANCE_AFTER
, C.SECURITY_GROUP_ID
, C.ATTRIBUTE_CATEGORY
, C.ATTRIBUTE1
, C.ATTRIBUTE2
, C.ATTRIBUTE3
, C.ATTRIBUTE4
, C.ATTRIBUTE5
, C.ATTRIBUTE6
, C.ATTRIBUTE7
, C.ATTRIBUTE8
, C.ATTRIBUTE9
, C.ATTRIBUTE10
, C.ATTRIBUTE11
, C.ATTRIBUTE12
, C.ATTRIBUTE13
, C.ATTRIBUTE14
, C.ATTRIBUTE15
, C.RESET_VALUE
, A.APPLICATION_USG_CODE
FROM AHL_MR_INTERVALS C
, AHL_MR_EFFECTIVITIES_APP_V A
, AHL_MR_HEADERS_APP_V B
WHERE A.MR_HEADER_ID=B.MR_HEADER_ID
AND A.MR_EFFECTIVITY_ID=C.MR_EFFECTIVITY_ID