VIEW: APPS.CSM_COUNTER_PROPERTIES_V

Source

View Text - Preformatted

SELECT ACC.ACCESS_ID , B.COUNTER_PROPERTY_ID , B.COUNTER_ID , TL.NAME , TL.DESCRIPTION , B.PROPERTY_DATA_TYPE , B.IS_NULLABLE , B.DEFAULT_VALUE , B.MINIMUM_VALUE , B.MAXIMUM_VALUE , B.UOM_CODE , B.START_DATE_ACTIVE , B.END_DATE_ACTIVE, B.PROPERTY_LOV_TYPE FROM CSM_COUNTER_PROPERTIES_ACC ACC, CSI_COUNTER_PROPERTIES_B B, CSI_COUNTER_PROPERTIES_TL TL WHERE ACC.COUNTER_PROPERTY_ID = B.COUNTER_PROPERTY_ID AND B.COUNTER_PROPERTY_ID = TL.COUNTER_PROPERTY_ID AND ACC.USER_ID = ASG_BASE.GET_USER_ID AND TL.LANGUAGE = ASG_BASE.GET_LANGUAGE

View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, B.COUNTER_PROPERTY_ID
, B.COUNTER_ID
, TL.NAME
, TL.DESCRIPTION
, B.PROPERTY_DATA_TYPE
, B.IS_NULLABLE
, B.DEFAULT_VALUE
, B.MINIMUM_VALUE
, B.MAXIMUM_VALUE
, B.UOM_CODE
, B.START_DATE_ACTIVE
, B.END_DATE_ACTIVE
, B.PROPERTY_LOV_TYPE
FROM CSM_COUNTER_PROPERTIES_ACC ACC
, CSI_COUNTER_PROPERTIES_B B
, CSI_COUNTER_PROPERTIES_TL TL
WHERE ACC.COUNTER_PROPERTY_ID = B.COUNTER_PROPERTY_ID
AND B.COUNTER_PROPERTY_ID = TL.COUNTER_PROPERTY_ID
AND ACC.USER_ID = ASG_BASE.GET_USER_ID
AND TL.LANGUAGE = ASG_BASE.GET_LANGUAGE