[Home] [Help] [Dependency Information]
Object Name: | CS_CP_AUDIT_MAINT_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | CS.CS_CP_AUDIT_MAINT_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row identifier | |
CUSTOMER_PRODUCT_ID | NUMBER | (15) | Yes | Product Identifier |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
OLD_CUSTOMER_ID | NUMBER | (15) | Customer identifier before the change | |
CURRENT_CUSTOMER_ID | NUMBER | (15) | Customer identifier after the change | |
OLD_SYSTEM_ID | NUMBER | (15) | System identifier before the change | |
CURRENT_SYSTEM_ID | NUMBER | (15) | System identifier after the change | |
OLD_PRODUCT_AGREEMENT_ID | NUMBER | Product agreement identifier before the change | ||
CURRENT_PRODUCT_AGREEMENT_ID | NUMBER | Product agreement identifier after the change | ||
OLD_PLATFORM_VERSION_ID | NUMBER | Platform version identifier before the change | ||
CURRENT_PLATFORM_VERSION_ID | NUMBER | Platform version identifier after the change | ||
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield column | |
CONTEXT | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield column | |
COMMENTS | VARCHAR2 | (240) | Comments | |
OLD_CP_STATUS_ID | NUMBER | (15) | Status identifier before the change | |
CURRENT_CP_STATUS_ID | NUMBER | (15) | Status identifier after the change | |
OLD_TYPE_CODE | VARCHAR2 | (30) | Product type before the change | |
CURRENT_TYPE_CODE | VARCHAR2 | (30) | Product type after the change | |
UPDATED_BY | VARCHAR2 | (100) | Yes | Refer to base table for detail |
OLD_CUSTOMER | VARCHAR2 | (360) | Yes | Old customer name |
NEW_CUSTOMER | VARCHAR2 | (360) | Yes | New customer name |
OLD_SYSTEM | VARCHAR2 | (50) | Old system name | |
NEW_SYSTEM | VARCHAR2 | (50) | New system name | |
OLD_PRODUCT_AGREEMENT | VARCHAR2 | (240) | Product agreement name before the change | |
NEW_PRODUCT_AGREEMENT | VARCHAR2 | (240) | Product agreement name after the change | |
OLD_PLATFORM_NAME | VARCHAR2 | (0) | Old platform name | |
NEW_PLATFORM_NAME | VARCHAR2 | (0) | New platform name | |
OLD_CP_STATUS | VARCHAR2 | (50) | Customer product status before the change | |
NEW_CP_STATUS | VARCHAR2 | (50) | Customer product status after the change | |
OLD_TYPE | VARCHAR2 | (80) | Old type | |
NEW_TYPE | VARCHAR2 | (80) | New type | |
SPLIT_CP_ID | NUMBER | Product identifier in installed base that was split | ||
SPLIT_CP_REFERENCE_NUMBER | VARCHAR2 | (30) | Product reference number in installed base that was split | |
OLD_CP_QUANTITY | NUMBER | (15) | Product quantity before the change | |
CURRENT_CP_QUANTITY | NUMBER | (15) | Product quantity after the change | |
CP_SPLIT_REASON_CODE | VARCHAR2 | (30) | Reason code for the split | |
CP_SPLIT_REASON | VARCHAR2 | (80) | Reason for the split |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, CUSTOMER_PRODUCT_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, OLD_CUSTOMER_ID
, CURRENT_CUSTOMER_ID
, OLD_SYSTEM_ID
, CURRENT_SYSTEM_ID
, OLD_PRODUCT_AGREEMENT_ID
, CURRENT_PRODUCT_AGREEMENT_ID
, OLD_PLATFORM_VERSION_ID
, CURRENT_PLATFORM_VERSION_ID
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, CONTEXT
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, COMMENTS
, OLD_CP_STATUS_ID
, CURRENT_CP_STATUS_ID
, OLD_TYPE_CODE
, CURRENT_TYPE_CODE
, UPDATED_BY
, OLD_CUSTOMER
, NEW_CUSTOMER
, OLD_SYSTEM
, NEW_SYSTEM
, OLD_PRODUCT_AGREEMENT
, NEW_PRODUCT_AGREEMENT
, OLD_PLATFORM_NAME
, NEW_PLATFORM_NAME
, OLD_CP_STATUS
, NEW_CP_STATUS
, OLD_TYPE
, NEW_TYPE
, SPLIT_CP_ID
, SPLIT_CP_REFERENCE_NUMBER
, OLD_CP_QUANTITY
, CURRENT_CP_QUANTITY
, CP_SPLIT_REASON_CODE
, CP_SPLIT_REASON
FROM APPS.CS_CP_AUDIT_MAINT_V;
APPS.CS_CP_AUDIT_MAINT_V is not referenced by any database object
|
|
|