VIEW: APPS.AHL_MR_INTERVALS_APP_V

Source

View Text - Preformatted

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.EARLIEST_DUE_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, C.CALC_DUEDATE_RULE_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

View Text - HTML Formatted

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.EARLIEST_DUE_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
, C.CALC_DUEDATE_RULE_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