VIEW: APPS.JTM_CS_COUNTER_PROPS_V

Source

View Text - Preformatted

SELECT A.ACCESS_ID , B.COUNTER_PROPERTY_ID , B.COUNTER_ID , B.NAME , B.DESCRIPTION , B.PROPERTY_DATA_TYPE , B.IS_NULLABLE , B.DEFAULT_VALUE , B.MINIMUM_VALUE , B.MAXIMUM_VALUE , B.UOM_CODE FROM JTM_CS_COUNTER_PROPS_ACC A , CS_COUNTER_PROPERTIES B WHERE A.COUNTER_PROPERTY_ID = B.COUNTER_PROPERTY_ID AND A.RESOURCE_ID = ASG_BASE.GET_RESOURCE_ID

View Text - HTML Formatted

SELECT A.ACCESS_ID
, B.COUNTER_PROPERTY_ID
, B.COUNTER_ID
, B.NAME
, B.DESCRIPTION
, B.PROPERTY_DATA_TYPE
, B.IS_NULLABLE
, B.DEFAULT_VALUE
, B.MINIMUM_VALUE
, B.MAXIMUM_VALUE
, B.UOM_CODE
FROM JTM_CS_COUNTER_PROPS_ACC A
, CS_COUNTER_PROPERTIES B
WHERE A.COUNTER_PROPERTY_ID = B.COUNTER_PROPERTY_ID
AND A.RESOURCE_ID = ASG_BASE.GET_RESOURCE_ID