VIEW: APPS.CSM_COUNTER_PROP_VALUES_V

Source

View Text - Preformatted

SELECT ACC.ACCESS_ID , B.COUNTER_PROP_VALUE_ID , B.COUNTER_VALUE_ID , B.COUNTER_PROPERTY_ID , B.PROPERTY_VALUE , B.VALUE_TIMESTAMP , B.OBJECT_VERSION_NUMBER , CSM_UTIL_PKG.GET_NUMBER(B.CREATED_BY) AS CREATED_BY , CSM_UTIL_PKG.GET_NUMBER(B.LAST_UPDATED_BY) AS LAST_UPDATED_BY FROM CSM_COUNTER_PROP_VALUES_ACC ACC , CSI_CTR_PROPERTY_READINGS B WHERE ACC.COUNTER_PROP_VALUE_ID = B.COUNTER_PROP_VALUE_ID AND ACC.USER_ID = ASG_BASE.GET_USER_ID

View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, B.COUNTER_PROP_VALUE_ID
, B.COUNTER_VALUE_ID
, B.COUNTER_PROPERTY_ID
, B.PROPERTY_VALUE
, B.VALUE_TIMESTAMP
, B.OBJECT_VERSION_NUMBER
, CSM_UTIL_PKG.GET_NUMBER(B.CREATED_BY) AS CREATED_BY
, CSM_UTIL_PKG.GET_NUMBER(B.LAST_UPDATED_BY) AS LAST_UPDATED_BY
FROM CSM_COUNTER_PROP_VALUES_ACC ACC
, CSI_CTR_PROPERTY_READINGS B
WHERE ACC.COUNTER_PROP_VALUE_ID = B.COUNTER_PROP_VALUE_ID
AND ACC.USER_ID = ASG_BASE.GET_USER_ID