[Home] [Help] [Dependency Information]
Object Name: | CSI_COUNTER_GROUPS_BC_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | CSI.CSI_COUNTER_GROUPS_BC_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
A backward compatible view for CS_COUNTER_GROUPS. This was created to support the pre R12 releases of Counters.
This view will show all the individual counters that is grouped and linked to same item instance or service contract lines.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COUNTER_GROUP_ID | NUMBER | The identifier of the counter group. | ||
NAME | VARCHAR2 | (100) | The name of the counter group. | |
DESCRIPTION | VARCHAR2 | (240) | The description of the counter group. | |
TEMPLATE_FLAG | VARCHAR2 | (1) | Indicates whether the counter group is a template or an instance. | |
LAST_UPDATE_DATE | DATE | Standard Who column | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard Who column | |
CREATION_DATE | DATE | Standard Who column | ||
CREATED_BY | NUMBER | (15) | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
START_DATE_ACTIVE | DATE | Effective from | ||
END_DATE_ACTIVE | DATE | Effective till | ||
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
CONTEXT | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
OBJECT_VERSION_NUMBER | NUMBER | Used internally. | ||
CREATED_FROM_CTR_GRP_TMPL_ID | NUMBER | See table description. | ||
ASSOCIATION_TYPE | VARCHAR2 | (30) | See table description. | |
SOURCE_OBJECT_CODE | VARCHAR2 | (30) | Valid only for instances. Can be either 'CP' or 'CONTRACT_LINE'. | |
SOURCE_OBJECT_ID | NUMBER | Mandatory only for instances. This must be valid for a particular SOURCE_OBJECT_CODE. | ||
SOURCE_COUNTER_GROUP_ID | NUMBER | See table description. | ||
SECURITY_GROUP_ID | NUMBER | Security group identifier |
Cut, paste (and edit) the following text to query this object:
SELECT COUNTER_GROUP_ID
, NAME
, DESCRIPTION
, TEMPLATE_FLAG
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CONTEXT
, OBJECT_VERSION_NUMBER
, CREATED_FROM_CTR_GRP_TMPL_ID
, ASSOCIATION_TYPE
, SOURCE_OBJECT_CODE
, SOURCE_OBJECT_ID
, SOURCE_COUNTER_GROUP_ID
, SECURITY_GROUP_ID
FROM APPS.CSI_COUNTER_GROUPS_BC_V;
|
|
|