[Home] [Help]
View: EAM_PM_ASSET_ACTIVITY_V
View Text
SELECT EPAAV.ACTIVITY_ASSOCIATION_ID
, EAMV.ASSET_NUMBER
, EAMV.METER_ID
, EAMV.METER_NAME
, EAMV.METER_UOM
, EAMV.VALUE_CHANGE_DIR
, EAMV.DESCRIPTION
, EAMV.USER_DEFINED_RATE
, EPAAV.CREATED_BY
, EPAAV.CREATION_DATE
, EPAAV.LAST_UPDATE_LOGIN
, EPAAV.LAST_UPDATE_DATE
, EPAAV.LAST_UPDATED_BY
FROM EAM_ASSET_METERS_V EAMV
, MTL_EAM_ASSET_ACTIVITIES EPAAV
WHERE USED_IN_SCHEDULING = 'Y' AND NVL(FROM_EFFECTIVE_DATE
, SYSDATE-1) < SYSDATE AND NVL(TO_EFFECTIVE_DATE
, SYSDATE+1) > SYSDATE AND EPAAV.SERIAL_NUMBER = EAMV.ASSET_NUMBER
Columns
Name |
ACTIVITY_ASSOCIATION_ID |
ASSET_NUMBER |
METER_ID |
METER_NAME |
METER_UOM |
VALUE_CHANGE_DIR |
DESCRIPTION |
USAGE_RATE |
CREATED_BY |
CREATION_DATE |
LAST_UPDATE_LOGIN |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |