Product: | EAM - Enterprise Asset Management |
---|---|
Description: | View used to get meter and meter reading interface details. |
Implementation/DBA Data: | APPS.EAM_METER_READINGS_INTERFACE_V |
SELECT MRI.ROWID
, MRI.INTERFACE_ID
, MRI.GROUP_ID
, MRI.PROCESS_PHASE
, ML1.MEANING PROCESS_PHASE_MEANING
, MRI.PROCESS_STATUS
, ML2.MEANING PROCESS_STATUS_MEANING
, MRI.METER_ID
, NVL(EM.METER_NAME
, MRI.METER_NAME)
, MRI.ORGANIZATION_ID
, DECODE(MRI.ORGANIZATION_ID
, NULL
, MRI.ORGANIZATION_CODE
, OOD.ORGANIZATION_CODE) ORGANIZATION_CODE
, MRI.WIP_ENTITY_ID
, NVL(WE.WIP_ENTITY_NAME
, MRI.WORK_ORDER_NAME)
, MRI.LAST_UPDATED_BY
, DECODE(MRI.LAST_UPDATED_BY
, NULL
, MRI.LAST_UPDATED_BY_NAME
, FU1.USER_NAME) LAST_UPDATED_BY_NAME
, MRI.LAST_UPDATE_DATE
, MRI.CREATED_BY
, DECODE(MRI.CREATED_BY
, NULL
, MRI.CREATED_BY_NAME
, FU2.USER_NAME) CREATED_BY_NAME
, MRI.CREATION_DATE
, MRI.READING_VALUE
, MRI.READING_DATE
, MRI.RESET_FLAG
, MRI.LIFE_TO_DATE_READING
, MRI.DESCRIPTION
, MRI.SOURCE_CODE
, MRI.SOURCE_LINE_ID
, MRI.LAST_UPDATE_LOGIN
, MRI.REQUEST_ID
, MRI.PROGRAM_ID
, MRI.PROGRAM_APPLICATION_ID
, MRI.PROGRAM_UPDATE_DATE
, MRI.ATTRIBUTE_CATEGORY
, MRI.ATTRIBUTE1
, MRI.ATTRIBUTE2
, MRI.ATTRIBUTE3
, MRI.ATTRIBUTE4
, MRI.ATTRIBUTE5
, MRI.ATTRIBUTE6
, MRI.ATTRIBUTE7
, MRI.ATTRIBUTE8
, MRI.ATTRIBUTE9
, MRI.ATTRIBUTE10
, MRI.ATTRIBUTE11
, MRI.ATTRIBUTE12
, MRI.ATTRIBUTE13
, MRI.ATTRIBUTE14
, MRI.ATTRIBUTE15
FROM MFG_LOOKUPS ML1
, MFG_LOOKUPS ML2
, ORG_ORGANIZATION_DEFINITIONS OOD
, FND_USER FU1
, FND_USER FU2
, WIP_ENTITIES WE
, EAM_METERS EM
, EAM_METER_READINGS_INTERFACE MRI
WHERE MRI.PROCESS_PHASE IS NOT NULL
AND MRI.PROCESS_STATUS IS NOT NULL
AND WE.ORGANIZATION_ID (+) = MRI.ORGANIZATION_ID
AND WE.WIP_ENTITY_ID (+) = MRI.WIP_ENTITY_ID
AND OOD.ORGANIZATION_ID (+) = MRI.ORGANIZATION_ID
AND EM.METER_ID (+) = MRI.METER_ID
AND ML1.LOOKUP_TYPE (+) = 'WIP_ML_PROCESS_PHASE'
AND ML1.LOOKUP_CODE (+) = MRI.PROCESS_PHASE
AND ML1.LOOKUP_CODE <> 3
AND ML2.LOOKUP_TYPE (+) = 'WIP_PROCESS_STATUS'
AND ML2.LOOKUP_CODE (+) = DECODE(MRI.PROCESS_STATUS
, 5
, 3
, MRI.PROCESS_STATUS)
AND FU1.USER_ID (+) = MRI.LAST_UPDATED_BY
AND FU2.USER_ID (+) = MRI.CREATED_BY