VIEW: APPS.JTM_CS_COUNTERS_V

Source

View Text - Preformatted

SELECT A.ACCESS_ID , B.COUNTER_ID , B.COUNTER_GROUP_ID , B.NAME , B.DESCRIPTION , B.STEP_VALUE , B.TYPE , B.UOM_CODE , B.DIRECTION FROM JTM_CS_COUNTERS_ACC A , CS_COUNTERS B WHERE A.COUNTER_ID = B.COUNTER_ID AND A.RESOURCE_ID = ASG_BASE.GET_RESOURCE_ID

View Text - HTML Formatted

SELECT A.ACCESS_ID
, B.COUNTER_ID
, B.COUNTER_GROUP_ID
, B.NAME
, B.DESCRIPTION
, B.STEP_VALUE
, B.TYPE
, B.UOM_CODE
, B.DIRECTION
FROM JTM_CS_COUNTERS_ACC A
, CS_COUNTERS B
WHERE A.COUNTER_ID = B.COUNTER_ID
AND A.RESOURCE_ID = ASG_BASE.GET_RESOURCE_ID