[Home] [Help] [Dependency Information]
Object Name: | CSI_COUNTER_GROUPS_BCV_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | CSI.CSI_COUNTER_GROUPS_BCV_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_V view. 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. | |
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. | ||
CREATED_FROM_CTR_GRP_TMPL_ID | NUMBER | See table description. | ||
ASSOCIATION_TYPE | VARCHAR2 | (30) | See table description. | |
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. |
Cut, paste (and edit) the following text to query this object:
SELECT COUNTER_GROUP_ID
, NAME
, DESCRIPTION
, TEMPLATE_FLAG
, SOURCE_OBJECT_CODE
, SOURCE_OBJECT_ID
, SOURCE_COUNTER_GROUP_ID
, CREATED_FROM_CTR_GRP_TMPL_ID
, ASSOCIATION_TYPE
, 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
FROM APPS.CSI_COUNTER_GROUPS_BCV_V;
|
|
|