eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.CS_CP_AUDIT_MAINT_V

Object Details

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

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

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.

[View Source]

Columns

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

Query Text

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;

Dependencies

[top of page]

APPS.CS_CP_AUDIT_MAINT_V references the following:

APPS: CSICUMPI_PUB - show dependent code; CS_CP_AUDIT; CS_CUSTOMER_PRODUCTS_ALL; CS_CUSTOMER_PRODUCT_STATUSES; CS_LOOKUPS; CS_SYSTEMS; FND_GLOBAL - show dependent code; FND_USER; HZ_CUST_ACCOUNTS; HZ_PARTIES; OE_AGREEMENTS

APPS.CS_CP_AUDIT_MAINT_V is not referenced by any database object