[Home] [Help] [Dependency Information]

VIEW: APPS.CSI_SYSTEMS_V

Object Details

Object Name:	CSI_SYSTEMS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CSI.CSI_SYSTEMS_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

Internal

[View Source]

Columns

Query Text

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

SELECT ROW_ID
,      SYSTEM_ID
,      OPERATING_UNIT_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      CUSTOMER_ID
,      CUSTOMER_NAME
,      CUSTOMER_PARTY_NUMBER
,      CUSTOMER_NUMBER
,      SYSTEM_TYPE_CODE
,      SYSTEM_TYPE
,      SYSTEM_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
,      OBJECT_VERSION_NUMBER
,      SHIP_TO_CUSTOMER_ID
,      SHIP_TO_CUSTOMER
,      SHIP_TO_CUSTOMER_NUMBER
,      SHIP_PARTY_TYPE
,      SHIP_FIRST_NAME
,      SHIP_LAST_NAME
,      SHIP_TO_SITE_NUMBER
,      SHIP_TO_LOCATION_ID
,      SHIP_DESCRIPTION
,      SHIP_TO_ADDRESS1
,      SHIP_TO_ADDRESS2
,      SHIP_TO_ADDRESS3
,      SHIP_TO_ADDRESS4
,      SHIP_TO_LOCATION
,      SHIP_STATE
,      SHIP_POSTAL_CODE
,      SHIP_COUNTRY
,      INSTALL_CUSTOMER_ID
,      INSTALL_CUSTOMER_NUMBER
,      INSTALL_CUSTOMER
,      INSTALL_PARTY_TYPE
,      INSTALL_FIRST_NAME
,      INSTALL_LAST_NAME
,      INSTALL_SITE_NUMBER
,      INSTALL_LOCATION_ID
,      INSTALL_DESCRIPTION
,      INSTALL_ADDRESS1
,      INSTALL_ADDRESS2
,      INSTALL_ADDRESS3
,      INSTALL_ADDRESS4
,      INSTALL_LOCATION
,      INSTALL_STATE
,      INSTALL_POSTAL_CODE
,      INSTALL_COUNTRY
,      BILL_TO_CUSTOMER_ID
,      BILL_TO_CUSTOMER_NUMBER
,      BILL_TO_CUSTOMER
,      BILL_PARTY_TYPE
,      BILL_FIRST_NAME
,      BILL_LAST_NAME
,      BILL_TO_SITE_NUMBER
,      BILL_TO_LOCATION_ID
,      BILL_DESCRIPTION
,      BILL_TO_ADDRESS1
,      BILL_TO_ADDRESS2
,      BILL_TO_ADDRESS3
,      BILL_TO_ADDRESS4
,      BILL_TO_LOCATION
,      BILL_STATE
,      BILL_POSTAL_CODE
,      COUNTRY
,      TECHNICAL_CONTACT_NUMBER
,      TECHNICAL_CONTACT
,      TECHNICAL_CONTACT_LAST_NAME
,      TECHNICAL_CONTACT_FIRST_NAME
,      SERVICE_ADMIN_CONTACT_NUMBER
,      SERVICE_ADMIN_CONTACT
,      ADMINISTRATIVE_LAST_NAME
,      ADMINISTRATIVE_FIRST_NAME
,      SHIP_TO_CONTACT_NUMBER
,      SHIP_TO_CONTACT
,      BILL_TO_CONTACT_NUMBER
,      BILL_TO_CONTACT
,      PARTY_ID
,      PARENT_NAME
,      PARENT_DESCRIPTION
,      PARENT_NUMBER
,      OPERATING_UNIT_NAME
FROM APPS.CSI_SYSTEMS_V;

Dependencies

[top of page]

APPS

CSI_LOOKUPS

CSI_SYSTEMS_VL

HR_OPERATING_UNITS

HZ_CUST_ACCOUNTS

HZ_CUST_ACCT_SITES_ALL

HZ_CUST_SITE_USES_ALL

HZ_LOCATIONS

HZ_PARTIES

HZ_PARTY_SITES

APPS

CSI_MASS_EDIT_PUB - show dependent code