[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | CSI_SYSTEMS_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  CSI.CSI_SYSTEMS_V
|
| Subobject Name: | |
| Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ROW_ID | ROWID | (10) | ||
| SYSTEM_ID | NUMBER | Yes | ||
| OPERATING_UNIT_ID | NUMBER | |||
| LAST_UPDATE_DATE | DATE | Yes | ||
| LAST_UPDATED_BY | NUMBER | (15) | Yes | |
| CREATION_DATE | DATE | Yes | ||
| CREATED_BY | NUMBER | (15) | Yes | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | ||
| CUSTOMER_ID | NUMBER | Yes | ||
| CUSTOMER_NAME | VARCHAR2 | (360) | Yes | |
| CUSTOMER_PARTY_NUMBER | VARCHAR2 | (30) | Yes | |
| CUSTOMER_NUMBER | VARCHAR2 | (30) | Yes | |
| SYSTEM_TYPE_CODE | VARCHAR2 | (30) | Yes | |
| SYSTEM_TYPE | VARCHAR2 | (80) | ||
| SYSTEM_NUMBER | VARCHAR2 | (30) | ||
| PARENT_SYSTEM_ID | NUMBER | |||
| TECHNICAL_CONTACT_ID | NUMBER | |||
| SERVICE_ADMIN_CONTACT_ID | NUMBER | |||
| INSTALL_SITE_USE_ID | NUMBER | |||
| BILL_TO_CONTACT_ID | NUMBER | |||
| BILL_TO_SITE_USE_ID | NUMBER | Yes | ||
| SHIP_TO_SITE_USE_ID | NUMBER | Yes | ||
| SHIP_TO_CONTACT_ID | NUMBER | |||
| COTERMINATE_DAY_MONTH | VARCHAR2 | (6) | ||
| START_DATE_ACTIVE | DATE | |||
| END_DATE_ACTIVE | DATE | |||
| AUTOCREATED_FROM_SYSTEM_ID | NUMBER | |||
| ATTRIBUTE1 | VARCHAR2 | (240) | ||
| ATTRIBUTE2 | VARCHAR2 | (240) | ||
| ATTRIBUTE3 | VARCHAR2 | (240) | ||
| ATTRIBUTE4 | VARCHAR2 | (240) | ||
| ATTRIBUTE5 | VARCHAR2 | (240) | ||
| ATTRIBUTE6 | VARCHAR2 | (240) | ||
| ATTRIBUTE7 | VARCHAR2 | (240) | ||
| ATTRIBUTE8 | VARCHAR2 | (240) | ||
| ATTRIBUTE9 | VARCHAR2 | (240) | ||
| ATTRIBUTE10 | VARCHAR2 | (240) | ||
| ATTRIBUTE11 | VARCHAR2 | (240) | ||
| ATTRIBUTE12 | VARCHAR2 | (240) | ||
| ATTRIBUTE13 | VARCHAR2 | (240) | ||
| ATTRIBUTE14 | VARCHAR2 | (240) | ||
| ATTRIBUTE15 | VARCHAR2 | (240) | ||
| CONTEXT | VARCHAR2 | (30) | ||
| CONFIG_SYSTEM_TYPE | VARCHAR2 | (30) | ||
| NAME | VARCHAR2 | (50) | Yes | |
| DESCRIPTION | VARCHAR2 | (240) | ||
| OBJECT_VERSION_NUMBER | NUMBER | Yes | ||
| SHIP_TO_CUSTOMER_ID | NUMBER | (15) | ||
| SHIP_TO_CUSTOMER | VARCHAR2 | (360) | ||
| SHIP_TO_CUSTOMER_NUMBER | VARCHAR2 | (30) | ||
| SHIP_PARTY_TYPE | VARCHAR2 | (30) | ||
| SHIP_FIRST_NAME | VARCHAR2 | (150) | ||
| SHIP_LAST_NAME | VARCHAR2 | (150) | ||
| SHIP_TO_SITE_NUMBER | VARCHAR2 | (30) | ||
| SHIP_TO_LOCATION_ID | NUMBER | (15) | ||
| SHIP_DESCRIPTION | VARCHAR2 | (2000) | ||
| SHIP_TO_ADDRESS1 | VARCHAR2 | (482) | ||
| SHIP_TO_ADDRESS2 | VARCHAR2 | (482) | ||
| SHIP_TO_ADDRESS3 | VARCHAR2 | (220) | ||
| SHIP_TO_ADDRESS4 | VARCHAR2 | (240) | ||
| SHIP_TO_LOCATION | VARCHAR2 | (60) | ||
| SHIP_STATE | VARCHAR2 | (60) | ||
| SHIP_POSTAL_CODE | VARCHAR2 | (60) | ||
| SHIP_COUNTRY | VARCHAR2 | (60) | ||
| INSTALL_CUSTOMER_ID | NUMBER | (15) | ||
| INSTALL_CUSTOMER_NUMBER | VARCHAR2 | (30) | ||
| INSTALL_CUSTOMER | VARCHAR2 | (360) | ||
| INSTALL_PARTY_TYPE | VARCHAR2 | (30) | ||
| INSTALL_FIRST_NAME | VARCHAR2 | (150) | ||
| INSTALL_LAST_NAME | VARCHAR2 | (150) | ||
| INSTALL_SITE_NUMBER | VARCHAR2 | (30) | ||
| INSTALL_LOCATION_ID | NUMBER | (15) | ||
| INSTALL_DESCRIPTION | VARCHAR2 | (2000) | ||
| INSTALL_ADDRESS1 | VARCHAR2 | (482) | ||
| INSTALL_ADDRESS2 | VARCHAR2 | (482) | ||
| INSTALL_ADDRESS3 | VARCHAR2 | (220) | ||
| INSTALL_ADDRESS4 | VARCHAR2 | (240) | ||
| INSTALL_LOCATION | VARCHAR2 | (60) | ||
| INSTALL_STATE | VARCHAR2 | (60) | ||
| INSTALL_POSTAL_CODE | VARCHAR2 | (60) | ||
| INSTALL_COUNTRY | VARCHAR2 | (60) | ||
| BILL_TO_CUSTOMER_ID | NUMBER | (15) | ||
| BILL_TO_CUSTOMER_NUMBER | VARCHAR2 | (30) | ||
| BILL_TO_CUSTOMER | VARCHAR2 | (360) | ||
| BILL_PARTY_TYPE | VARCHAR2 | (30) | ||
| BILL_FIRST_NAME | VARCHAR2 | (150) | ||
| BILL_LAST_NAME | VARCHAR2 | (150) | ||
| BILL_TO_SITE_NUMBER | VARCHAR2 | (30) | ||
| BILL_TO_LOCATION_ID | NUMBER | (15) | ||
| BILL_DESCRIPTION | VARCHAR2 | (2000) | ||
| BILL_TO_ADDRESS1 | VARCHAR2 | (482) | ||
| BILL_TO_ADDRESS2 | VARCHAR2 | (482) | ||
| BILL_TO_ADDRESS3 | VARCHAR2 | (220) | ||
| BILL_TO_ADDRESS4 | VARCHAR2 | (240) | ||
| BILL_TO_LOCATION | VARCHAR2 | (60) | ||
| BILL_STATE | VARCHAR2 | (60) | ||
| BILL_POSTAL_CODE | VARCHAR2 | (60) | ||
| COUNTRY | VARCHAR2 | (60) | ||
| TECHNICAL_CONTACT_NUMBER | VARCHAR2 | (30) | ||
| TECHNICAL_CONTACT | VARCHAR2 | (360) | ||
| TECHNICAL_CONTACT_LAST_NAME | VARCHAR2 | (150) | ||
| TECHNICAL_CONTACT_FIRST_NAME | VARCHAR2 | (150) | ||
| SERVICE_ADMIN_CONTACT_NUMBER | VARCHAR2 | (30) | ||
| SERVICE_ADMIN_CONTACT | VARCHAR2 | (360) | ||
| ADMINISTRATIVE_LAST_NAME | VARCHAR2 | (150) | ||
| ADMINISTRATIVE_FIRST_NAME | VARCHAR2 | (150) | ||
| SHIP_TO_CONTACT_NUMBER | VARCHAR2 | (30) | ||
| SHIP_TO_CONTACT | VARCHAR2 | (360) | ||
| BILL_TO_CONTACT_NUMBER | VARCHAR2 | (30) | ||
| BILL_TO_CONTACT | VARCHAR2 | (360) | ||
| PARTY_ID | NUMBER | (15) | Yes | |
| PARENT_NAME | VARCHAR2 | (50) | ||
| PARENT_DESCRIPTION | VARCHAR2 | (240) | ||
| PARENT_NUMBER | VARCHAR2 | (30) | ||
| OPERATING_UNIT_NAME | VARCHAR2 | (240) |
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;
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
|
|
|
|