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_SYSTEMS_MAINT_V

Object Details

Object Name:	CS_CP_SYSTEMS_MAINT_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CS.CS_CP_SYSTEMS_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
SYSTEM_ID	NUMBER		Yes	System 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_ID	NUMBER		Yes	Customer identifier
CUSTOMER_NAME	VARCHAR2	(360)		Customer name
SYSTEM_TYPE_CODE	VARCHAR2	(30)	Yes	System type lookup code
SERIAL_NUMBER	VARCHAR2	(30)		System number
PARENT_SYSTEM_ID	NUMBER			Parent system identifier
TECHNICAL_CONTACT_ID	NUMBER			Technical contact identifier
SERVICE_ADMIN_CONTACT_ID	NUMBER			Administration contact identifier
INSTALL_SITE_USE_ID	NUMBER			Installed site identifier
BILL_TO_CONTACT_ID	NUMBER			Bill-to contact identifier
BILL_TO_SITE_USE_ID	NUMBER		Yes	Identifier for bill-to site use
SHIP_TO_SITE_USE_ID	NUMBER		Yes	Identifier for ship-to site use
SHIP_TO_CONTACT_ID	NUMBER			Ship-to contact identifier
COTERMINATE_DAY_MONTH	VARCHAR2	(6)		The day and month when every service and product under system expires
START_DATE_ACTIVE	DATE			Start date for the system
END_DATE_ACTIVE	DATE			End date for the system
AUTOCREATED_FROM_SYSTEM_ID	NUMBER			System identifier for the copied from system
ATTRIBUTE1	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(240)		Descriptive flexfield segment
CONTEXT	VARCHAR2	(30)		Descriptive flexfield structure defining column
CONFIG_SYSTEM_TYPE	VARCHAR2	(30)		Describes the type of system used by oracle product
NAME	VARCHAR2	(50)	Yes	System name
DESCRIPTION	VARCHAR2	(240)		Description of system
SHIP_PARTY_ID	NUMBER	(15)		Ship-to information of the system
SHIP_PARTY_NAME	VARCHAR2	(360)		Ship-to information of the system
SHIP_PARTY_TYPE	VARCHAR2	(30)		Ship-to information of the system
SHIP_FIRST_NAME	VARCHAR2	(150)		Ship-to information of the system
SHIP_LAST_NAME	VARCHAR2	(150)		Ship-to information of the system
SHIP_LOCATION	NUMBER	(15)		Ship-to information of the system
SHIP_DESCRIPTION	VARCHAR2	(2000)		Ship-to information of the system
SHIP_ADDRESS1	VARCHAR2	(240)		Ship-to information of the system
SHIP_ADDRESS2	VARCHAR2	(240)		Ship-to information of the system
SHIP_ADDRESS3	VARCHAR2	(240)		Ship-to information of the system
SHIP_ADDRESS4	VARCHAR2	(240)		Ship-to information of the system
INSTALL_PARTY_ID	NUMBER	(15)		Install information of the system
INSTALL_PARTY_NAME	VARCHAR2	(360)		Install information of the system
INSTALL_PARTY_TYPE	VARCHAR2	(30)		Install information of the system
INSTALL_FIRST_NAME	VARCHAR2	(150)		Install information of the system
INSTALL_LAST_NAME	VARCHAR2	(150)		Install information of the system
INSTALL_LOCATION	NUMBER	(15)		Install information of the system
INSTALL_DESCRIPTION	VARCHAR2	(2000)		Install information of the system
INSTALL_ADDRESS1	VARCHAR2	(240)		Install information of the system
INSTALL_ADDRESS2	VARCHAR2	(240)		Install information of the system
INSTALL_ADDRESS3	VARCHAR2	(240)		Install information of the system
INSTALL_ADDRESS4	VARCHAR2	(240)		Install information of the system
BILL_PARTY_ID	NUMBER	(15)		Bill-to information of the system
BILL_PARTY_NAME	VARCHAR2	(360)		Bill-to information of the system
BILL_PARTY_TYPE	VARCHAR2	(30)		Bill-to information of the system
BILL_FIRST_NAME	VARCHAR2	(150)		Bill-to information of the system
BILL_LAST_NAME	VARCHAR2	(150)		Bill-to information of the system
BILL_LOCATION	NUMBER	(15)		Bill-to information of the system
BILL_DESCRIPTION	VARCHAR2	(2000)		Bill-to information of the system
BILL_ADDRESS1	VARCHAR2	(240)		Bill-to information of the system
BILL_ADDRESS2	VARCHAR2	(240)		Bill-to information of the system
BILL_ADDRESS3	VARCHAR2	(240)		Bill-to information of the system
BILL_ADDRESS4	VARCHAR2	(240)		Bill-to information of the system
TECHNICAL_CONTACT	VARCHAR2	(360)		Name of technical contact
ADMINISTRATIVE_CONTACT	VARCHAR2	(360)		Name of administrative contact
SHIP_CONTACT	VARCHAR2	(360)		Shipping contact
BILL_CONTACT	VARCHAR2	(360)		Billing contact

Query Text

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


SELECT ROW_ID
,      SYSTEM_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      CUSTOMER_ID
,      CUSTOMER_NAME
,      SYSTEM_TYPE_CODE
,      SERIAL_NUMBER
,      PARENT_SYSTEM_ID
,      TECHNICAL_CONTACT_ID
,      SERVICE_ADMIN_CONTACT_ID
,      INSTALL_SITE_USE_ID
,      BILL_TO_CONTACT_ID
,      BILL_TO_SITE_USE_ID
,      SHIP_TO_SITE_USE_ID
,      SHIP_TO_CONTACT_ID
,      COTERMINATE_DAY_MONTH
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      AUTOCREATED_FROM_SYSTEM_ID
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CONTEXT
,      CONFIG_SYSTEM_TYPE
,      NAME
,      DESCRIPTION
,      SHIP_PARTY_ID
,      SHIP_PARTY_NAME
,      SHIP_PARTY_TYPE
,      SHIP_FIRST_NAME
,      SHIP_LAST_NAME
,      SHIP_LOCATION
,      SHIP_DESCRIPTION
,      SHIP_ADDRESS1
,      SHIP_ADDRESS2
,      SHIP_ADDRESS3
,      SHIP_ADDRESS4
,      INSTALL_PARTY_ID
,      INSTALL_PARTY_NAME
,      INSTALL_PARTY_TYPE
,      INSTALL_FIRST_NAME
,      INSTALL_LAST_NAME
,      INSTALL_LOCATION
,      INSTALL_DESCRIPTION
,      INSTALL_ADDRESS1
,      INSTALL_ADDRESS2
,      INSTALL_ADDRESS3
,      INSTALL_ADDRESS4
,      BILL_PARTY_ID
,      BILL_PARTY_NAME
,      BILL_PARTY_TYPE
,      BILL_FIRST_NAME
,      BILL_LAST_NAME
,      BILL_LOCATION
,      BILL_DESCRIPTION
,      BILL_ADDRESS1
,      BILL_ADDRESS2
,      BILL_ADDRESS3
,      BILL_ADDRESS4
,      TECHNICAL_CONTACT
,      ADMINISTRATIVE_CONTACT
,      SHIP_CONTACT
,      BILL_CONTACT
FROM APPS.CS_CP_SYSTEMS_MAINT_V;

Dependencies

[top of page]

APPS.CS_CP_SYSTEMS_MAINT_V references the following:

APPS: CS_SYSTEMS; HZ_CUST_ACCOUNTS; HZ_CUST_ACCT_SITES_ALL; HZ_LOCATIONS; HZ_PARTIES; HZ_PARTY_SITES

APPS.CS_CP_SYSTEMS_MAINT_V is not referenced by any database object