[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | CSI_COUNTER_ASSOCIATIONS_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  CSI.CSI_COUNTER_ASSOCIATIONS_V
|
| Subobject Name: | |
| Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
A supplementary view used to simplify forms coding. This view contains the association information between the counter instance and the item instances. It also contains the association between the counter instance and the service contract lines.
Valid source_object_code are 'CP' and 'CONTRACT_LINE' only. If the source_object_code is 'CP' then it is associated to item instance else it associated to the service contract lines.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| INSTANCE_ASSOCIATION_ID | NUMBER | Yes | Internally generated instance association ID | |
| SOURCE_OBJECT_CODE | VARCHAR2 | (30) | Yes | Source object code |
| SOURCE_OBJECT_ID | NUMBER | Yes | Source object identifier | |
| OBJECT_VERSION_NUMBER | NUMBER | Yes | Object version number | |
| LAST_UPDATE_DATE | DATE | Yes | Standard WHO Column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard WHO Column |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO Column | |
| CREATION_DATE | DATE | Yes | Standard WHO Column | |
| CREATED_BY | NUMBER | (15) | Yes | Standard WHO Column |
| ATTRIBUTE1 | VARCHAR2 | (150) | Standard DFF Column | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Standard DFF Column | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Standard DFF Column | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Standard DFF Column | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Standard DFF Column | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Standard DFF Column | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Standard DFF Column | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Standard DFF Column | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Standard DFF Column | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Standard DFF Column | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Standard DFF Column | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Standard DFF Column | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Standard DFF Column | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Standard DFF Column | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Standard DFF Column | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Standard DFF Column | |
| SECURITY_GROUP_ID | NUMBER | Security group identifier | ||
| MIGRATED_FLAG | VARCHAR2 | (1) | Flag to indicate if this is a migrated record | |
| COUNTER_ID | NUMBER | Counter identifier | ||
| START_DATE_ACTIVE | DATE | Activation start date | ||
| END_DATE_ACTIVE | DATE | Activation end date | ||
| MAINT_ORGANIZATION_ID | NUMBER | eAM Maintenance Organization Identifier | ||
| PRIMARY_FAILURE_FLAG | VARCHAR2 | (1) | Indicator if the counter/meter is a failure counter/meter. |
Cut, paste (and edit) the following text to query this object:
SELECT INSTANCE_ASSOCIATION_ID
, SOURCE_OBJECT_CODE
, SOURCE_OBJECT_ID
, OBJECT_VERSION_NUMBER
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE_CATEGORY
, SECURITY_GROUP_ID
, MIGRATED_FLAG
, COUNTER_ID
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, MAINT_ORGANIZATION_ID
, PRIMARY_FAILURE_FLAG
FROM APPS.CSI_COUNTER_ASSOCIATIONS_V;
APPS
CSI_COUNTER_ASSOCIATIONS
APPS.CSI_COUNTER_ASSOCIATIONS_V is not referenced by any database object
|
|
|
|