DBA Data[Home] [Help]

VIEW: APPS.CSM_COUNTER_GROUPS_V

Source

View Text - Preformatted

SELECT ACC.ACCESS_ID , B.COUNTER_GROUP_ID , B.NAME , B.DESCRIPTION , B.SOURCE_OBJECT_CODE , B.SOURCE_OBJECT_ID , B.START_DATE_ACTIVE , B.END_DATE_ACTIVE FROM CSM_COUNTER_GROUPS_ACC ACC , CS_COUNTER_GROUPS B WHERE ACC.COUNTER_GROUP_ID = B.COUNTER_GROUP_ID AND ACC.USER_ID = ASG_BASE.GET_USER_ID
View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, B.COUNTER_GROUP_ID
, B.NAME
, B.DESCRIPTION
, B.SOURCE_OBJECT_CODE
, B.SOURCE_OBJECT_ID
, B.START_DATE_ACTIVE
, B.END_DATE_ACTIVE
FROM CSM_COUNTER_GROUPS_ACC ACC
, CS_COUNTER_GROUPS B
WHERE ACC.COUNTER_GROUP_ID = B.COUNTER_GROUP_ID
AND ACC.USER_ID = ASG_BASE.GET_USER_ID