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]

TABLE: CS.CS_CP_AUDIT

Object Details

Object Name:	CS_CP_AUDIT
Object Type:	TABLE
Owner:	CS
FND Design Data:	CS.CS_CP_AUDIT
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.

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CS_CP_AUDIT_U1	NORMAL	UNIQUE	APPS_TS_ARCHIVE	CP_AUDIT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CUSTOMER_PRODUCT_ID	NUMBER	(15)	Yes	Customer 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
CUSTOMER_CHANGED_FLAG	VARCHAR2	(1)
OLD_CUSTOMER_ID	NUMBER	(15)		Customer identifier before the change
CURRENT_CUSTOMER_ID	NUMBER	(15)		Customer identifier after the change
SYSTEM_CHANGED_FLAG	VARCHAR2	(1)
OLD_SYSTEM_ID	NUMBER	(15)		System identifier before the change
CURRENT_SYSTEM_ID	NUMBER	(15)		System identifier after the change
PRODUCT_AGREEMENT_CHANGED_FLAG	VARCHAR2	(1)
OLD_PRODUCT_AGREEMENT_ID	NUMBER			Product agreement identifier before the change
CURRENT_PRODUCT_AGREEMENT_ID	NUMBER			Product agreement identifier after the change
SERVICE_AGREEMENT_CHANGED_FLAG	VARCHAR2	(1)
OLD_SERVICE_AGREEMENT_ID	NUMBER	(15)
CURRENT_SERVICE_AGREEMENT_ID	NUMBER	(15)
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
COMMENTS	VARCHAR2	(240)		Comments
CP_STATUS_CHANGED_FLAG	VARCHAR2	(1)
OLD_CP_STATUS_ID	NUMBER	(15)		Status identifier before the change
CURRENT_CP_STATUS_ID	NUMBER	(15)		Status identifier after the change
TYPE_CODE_CHANGED_FLAG	VARCHAR2	(1)
OLD_TYPE_CODE	VARCHAR2	(30)		Customer product type before the change
CURRENT_TYPE_CODE	VARCHAR2	(30)		Customer product type after the change
SPLIT_CP_ID	NUMBER			The identifier of the product in the installed base that was split.
CP_QUANTITY_CHANGED_FLAG	VARCHAR2	(1)
OLD_CP_QUANTITY	NUMBER	(15)		The quantity before the change.
CURRENT_CP_QUANTITY	NUMBER	(15)		The current quantity after the split
CP_SPLIT_REASON_CODE	VARCHAR2	(30)		The reason for the split
CP_AUDIT_ID	NUMBER		Yes	Identifier for Audit Record
OLD_INVENTORY_ITEM_ID	NUMBER	(15)		Product identifier before the change.
CURRENT_INVENTORY_ITEM_ID	NUMBER			Product identifier after the change.
OLD_ORIGINAL_ORDER_LINE_ID	NUMBER			Order line identifier before the change
CURRENT_ORIGINAL_ORDER_LINE_ID	NUMBER			Order line identifier after the change
OLD_LOT_NUMBER	VARCHAR2	(30)		Lot number of product before the change.
CURRENT_LOT_NUMBER	VARCHAR2	(240)		Lot number of the product after the change.
OLD_SERIAL_NUMBER	VARCHAR2	(30)		The serial number before the change.
CURRENT_PROJECT_ID	NUMBER			Project identified after the change
OLD_PROJECT_ID	NUMBER			Project identified before the change
CURRENT_TASK_ID	NUMBER			Task identifier after the change
OLD_TASK_ID	NUMBER			Task identifier before the change
CURRENT_SERIAL_NUMBER	VARCHAR2	(30)		Serial number after the change.
OLD_INSTALLATION_DATE	DATE			The installation date before the change.
CURRENT_INSTALLATION_DATE	DATE			The installation date after the change.
OLD_SHIP_TO_SITE_USE_ID	NUMBER	(15)		The identifier of ship to site before the change.
CURRENT_SHIP_TO_SITE_USE_ID	NUMBER			The identifier of ship to site after the change.
OLD_BILL_TO_SITE_USE_ID	NUMBER	(15)		The identifier of bill to site before the change.
CURRENT_BILL_TO_SITE_USE_ID	NUMBER			The identifier of bill to site after the change.
OLD_INSTALL_SITE_USE_ID	NUMBER	(15)		The identifier of install site before the change.
CURRENT_INSTALL_SITE_USE_ID	NUMBER			The identifier of install site after the change.
OLD_UNIT_OF_MEASURE_CODE	VARCHAR2	(25)		The unit of measure code before the change.
CURRENT_UNIT_OF_MEASURE_CODE	VARCHAR2	(240)		The unit of measure code after the change.
OLD_SHIPPED_DATE	DATE			The shipped date before the change.
CURRENT_SHIPPED_DATE	DATE			The shipped date after the change.
OLD_RETURN_BY_DATE	DATE			The return date before the change.
CURRENT_RETURN_BY_DATE	DATE			The return date after the change.
OLD_ACTUAL_RETURNED_DATE	DATE			The actual return date before the change.
CURRENT_ACTUAL_RETURNED_DATE	DATE			The actual return date after the change.
OLD_RMA_LINE_ID	NUMBER	(15)		The identifier of the rma line before the change.
CURRENT_RMA_LINE_ID	NUMBER			The identifier of the rma line after the change.
OLD_CONFIG_START_DATE	DATE			The start date of the configuration before the change.
CURRENT_CONFIG_START_DATE	DATE			The start date of the configuration after the change.
OLD_CONFIG_END_DATE	DATE			The end date of the configuration before the change.
CURRENT_CONFIG_END_DATE	DATE			The end date of the configuration after the change.
OLD_CONFIG_TYPE	VARCHAR2	(30)		The configuration type before the change.
CURRENT_CONFIG_TYPE	VARCHAR2	(30)		The configuration type after the change.
OLD_CONFIG_PARENT_ID	NUMBER			Parent identifier for the configuration before the change
CURRENT_CONFIG_PARENT_ID	NUMBER			Parent identifier for the configuration after the change
OLD_PLATFORM_VERSION_ID	NUMBER			The identifier of the platform version before the change.
CURRENT_PLATFORM_VERSION_ID	NUMBER			The identifier of the platform version after the change.
OLD_START_DATE_ACTIVE	DATE			The effectivity start date before the change.
CURRENT_START_DATE_ACTIVE	VARCHAR2	(240)		The effectivity start date after the change.
OLD_END_DATE_ACTIVE	DATE			The effectivity end date before the change.
CURRENT_END_DATE_ACTIVE	VARCHAR2	(240)		The effectivity end date after the change.
OLD_MERCHANT_VIEW_FLAG	VARCHAR2	(1)		Merchant view flag before the change
CURRENT_MERCHANT_VIEW_FLAG	VARCHAR2	(1)		Merchant view flag after the change
OLD_CUSTOMER_VIEW_FLAG	VARCHAR2	(1)		Customer view flag before the change
CURRENT_CUSTOMER_VIEW_FLAG	VARCHAR2	(1)		Customer view flag after the change
OBJECT_VERSION_NUMBER	NUMBER		Yes	Sequential number used for database locking control
SECURITY_GROUP_ID	NUMBER			Used in hosted environments
UPGRADED_STATUS_FLAG	VARCHAR2	(1)
VALID_FOR_CSI_MIGRATION	VARCHAR2	(1)
MIGRATED_STATUS_FLAG	VARCHAR2	(1)
OLD_BILL_TO_SITE_USE	NUMBER
OLD_SHIP_TO_SITE_USE	NUMBER
CURRENT_BILL_TO_SITE_USE	NUMBER
CURRENT_SHIP_TO_SITE_USE	NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CUSTOMER_PRODUCT_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      CUSTOMER_CHANGED_FLAG
,      OLD_CUSTOMER_ID
,      CURRENT_CUSTOMER_ID
,      SYSTEM_CHANGED_FLAG
,      OLD_SYSTEM_ID
,      CURRENT_SYSTEM_ID
,      PRODUCT_AGREEMENT_CHANGED_FLAG
,      OLD_PRODUCT_AGREEMENT_ID
,      CURRENT_PRODUCT_AGREEMENT_ID
,      SERVICE_AGREEMENT_CHANGED_FLAG
,      OLD_SERVICE_AGREEMENT_ID
,      CURRENT_SERVICE_AGREEMENT_ID
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CONTEXT
,      COMMENTS
,      CP_STATUS_CHANGED_FLAG
,      OLD_CP_STATUS_ID
,      CURRENT_CP_STATUS_ID
,      TYPE_CODE_CHANGED_FLAG
,      OLD_TYPE_CODE
,      CURRENT_TYPE_CODE
,      SPLIT_CP_ID
,      CP_QUANTITY_CHANGED_FLAG
,      OLD_CP_QUANTITY
,      CURRENT_CP_QUANTITY
,      CP_SPLIT_REASON_CODE
,      CP_AUDIT_ID
,      OLD_INVENTORY_ITEM_ID
,      CURRENT_INVENTORY_ITEM_ID
,      OLD_ORIGINAL_ORDER_LINE_ID
,      CURRENT_ORIGINAL_ORDER_LINE_ID
,      OLD_LOT_NUMBER
,      CURRENT_LOT_NUMBER
,      OLD_SERIAL_NUMBER
,      CURRENT_PROJECT_ID
,      OLD_PROJECT_ID
,      CURRENT_TASK_ID
,      OLD_TASK_ID
,      CURRENT_SERIAL_NUMBER
,      OLD_INSTALLATION_DATE
,      CURRENT_INSTALLATION_DATE
,      OLD_SHIP_TO_SITE_USE_ID
,      CURRENT_SHIP_TO_SITE_USE_ID
,      OLD_BILL_TO_SITE_USE_ID
,      CURRENT_BILL_TO_SITE_USE_ID
,      OLD_INSTALL_SITE_USE_ID
,      CURRENT_INSTALL_SITE_USE_ID
,      OLD_UNIT_OF_MEASURE_CODE
,      CURRENT_UNIT_OF_MEASURE_CODE
,      OLD_SHIPPED_DATE
,      CURRENT_SHIPPED_DATE
,      OLD_RETURN_BY_DATE
,      CURRENT_RETURN_BY_DATE
,      OLD_ACTUAL_RETURNED_DATE
,      CURRENT_ACTUAL_RETURNED_DATE
,      OLD_RMA_LINE_ID
,      CURRENT_RMA_LINE_ID
,      OLD_CONFIG_START_DATE
,      CURRENT_CONFIG_START_DATE
,      OLD_CONFIG_END_DATE
,      CURRENT_CONFIG_END_DATE
,      OLD_CONFIG_TYPE
,      CURRENT_CONFIG_TYPE
,      OLD_CONFIG_PARENT_ID
,      CURRENT_CONFIG_PARENT_ID
,      OLD_PLATFORM_VERSION_ID
,      CURRENT_PLATFORM_VERSION_ID
,      OLD_START_DATE_ACTIVE
,      CURRENT_START_DATE_ACTIVE
,      OLD_END_DATE_ACTIVE
,      CURRENT_END_DATE_ACTIVE
,      OLD_MERCHANT_VIEW_FLAG
,      CURRENT_MERCHANT_VIEW_FLAG
,      OLD_CUSTOMER_VIEW_FLAG
,      CURRENT_CUSTOMER_VIEW_FLAG
,      OBJECT_VERSION_NUMBER
,      SECURITY_GROUP_ID
,      UPGRADED_STATUS_FLAG
,      VALID_FOR_CSI_MIGRATION
,      MIGRATED_STATUS_FLAG
,      OLD_BILL_TO_SITE_USE
,      OLD_SHIP_TO_SITE_USE
,      CURRENT_BILL_TO_SITE_USE
,      CURRENT_SHIP_TO_SITE_USE
FROM CS.CS_CP_AUDIT;

Dependencies

[top of page]

CS.CS_CP_AUDIT does not reference any database object

CS.CS_CP_AUDIT is referenced by following:

APPS: CS_CP_AUDIT