VIEW: APPS.CSF_M_COUNTERS_V

Source

View Text - Preformatted

SELECT acc.access_id, b.counter_id, acc.user_id, b.group_id as COUNTER_GROUP_ID, ass.source_object_id, tl.name, b.uom_code, b.direction, b.start_date_active cntr_start_date, b.end_date_active cntr_end_date, grp.start_date_active cntr_grp_start_date, grp.end_date_active cntr_grp_end_date, grp.DESCRIPTION , b.STEP_VALUE , b.COUNTER_TYPE AS TYPE, b.ATTRIBUTE_CATEGORY AS CONTEXT, b.attribute1, b.attribute2, b.attribute3, b.attribute4, b.attribute5, b.attribute6, b.attribute7, b.attribute8, b.attribute9, b.attribute10, b.attribute11, b.attribute12, b.attribute13, b.attribute14, b.attribute15 FROM CSI_COUNTERS_B b, CSI_COUNTERS_TL tl, CSI_COUNTER_ASSOCIATIONS ass, CS_CSI_COUNTER_GROUPS grp, csm_counters_acc acc WHERE b.counter_id = ass.counter_id AND acc.counter_id = b.counter_id AND b.counter_id = tl.counter_id AND ass.source_object_code = 'CP' AND b.counter_type = 'REGULAR' AND grp.counter_group_id(+) = b.group_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_ID
, ACC.USER_ID
, B.GROUP_ID AS COUNTER_GROUP_ID
, ASS.SOURCE_OBJECT_ID
, TL.NAME
, B.UOM_CODE
, B.DIRECTION
, B.START_DATE_ACTIVE CNTR_START_DATE
, B.END_DATE_ACTIVE CNTR_END_DATE
, GRP.START_DATE_ACTIVE CNTR_GRP_START_DATE
, GRP.END_DATE_ACTIVE CNTR_GRP_END_DATE
, GRP.DESCRIPTION
, B.STEP_VALUE
, B.COUNTER_TYPE AS TYPE
, B.ATTRIBUTE_CATEGORY AS CONTEXT
, B.ATTRIBUTE1
, B.ATTRIBUTE2
, B.ATTRIBUTE3
, B.ATTRIBUTE4
, B.ATTRIBUTE5
, B.ATTRIBUTE6
, B.ATTRIBUTE7
, B.ATTRIBUTE8
, B.ATTRIBUTE9
, B.ATTRIBUTE10
, B.ATTRIBUTE11
, B.ATTRIBUTE12
, B.ATTRIBUTE13
, B.ATTRIBUTE14
, B.ATTRIBUTE15
FROM CSI_COUNTERS_B B
, CSI_COUNTERS_TL TL
, CSI_COUNTER_ASSOCIATIONS ASS
, CS_CSI_COUNTER_GROUPS GRP
, CSM_COUNTERS_ACC ACC
WHERE B.COUNTER_ID = ASS.COUNTER_ID
AND ACC.COUNTER_ID = B.COUNTER_ID
AND B.COUNTER_ID = TL.COUNTER_ID
AND ASS.SOURCE_OBJECT_CODE = 'CP'
AND B.COUNTER_TYPE = 'REGULAR'
AND GRP.COUNTER_GROUP_ID(+) = B.GROUP_ID
AND ACC.USER_ID = ASG_BASE.GET_USER_ID
AND TL.LANGUAGE = ASG_BASE.GET_LANGUAGE