VIEW: APPS.EAM_METER_READINGS_INTERFACE_V

Source

View Text - Preformatted

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, mri.reading_change, mri.disable_flag 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

View Text - HTML Formatted

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
, MRI.READING_CHANGE
, MRI.DISABLE_FLAG
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