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

VIEW: APPS.OKX_SYSTEMS_V

Object Details
Object Name: OKX_SYSTEMS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKX.OKX_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
Name Datatype Length Mandatory Comments
ID1 NUMBER
Yes System identifier
ID2 CHAR (1)
(Multi-part) Primary Key
CUSTOMER_ID NUMBER
Yes Customer identifier
NAME VARCHAR2 (50) Yes System name
DESCRIPTION VARCHAR2 (240)
System description
SERIAL_NUMBER VARCHAR2 (30)
System number
COTERMINATE_DAY_MONTH VARCHAR2 (6)
The day and month when every service and product under the system expires
INSTALL_SITE_USE_ID NUMBER

Installed site identifier
BILL_TO_SITE_USE_ID NUMBER
Yes Identifier for bill-to site use
START_DATE_ACTIVE DATE

Start date for the system
END_DATE_ACTIVE DATE

End date for the system
ORG_ID VARCHAR2 (0)
Operating unit identifier
SHIP_TO_SITE_USE_ID NUMBER
Yes Identifier for ship-to site use
SYSTEM_TYPE_CODE VARCHAR2 (30) Yes System type lookup code
PARENT_SYSTEM_ID NUMBER

Parent system identifier
CONFIG_SYSTEM_TYPE VARCHAR2 (30)
Describes the type of system used by Oracle Product Configurator to validate configurations owned by the customer
STATUS VARCHAR2 (1)
Status
INVENTORY_ITEM_ID VARCHAR2 (0)
Inventory item identifier
ORGANIZATION_ID VARCHAR2 (0)
Organization identifier
PRIMARY_UOM_CODE VARCHAR2 (0)
Query Text

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


SELECT ID1
,      ID2
,      CUSTOMER_ID
,      NAME
,      DESCRIPTION
,      SERIAL_NUMBER
,      COTERMINATE_DAY_MONTH
,      INSTALL_SITE_USE_ID
,      BILL_TO_SITE_USE_ID
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      ORG_ID
,      SHIP_TO_SITE_USE_ID
,      SYSTEM_TYPE_CODE
,      PARENT_SYSTEM_ID
,      CONFIG_SYSTEM_TYPE
,      STATUS
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      PRIMARY_UOM_CODE
FROM APPS.OKX_SYSTEMS_V;

Dependencies

[top of page]

APPS.OKX_SYSTEMS_V references the following:

SchemaAPPS
SynonymCS_SYSTEMS_ALL_B
SynonymCS_SYSTEMS_ALL_TL
APPS.OKX_SYSTEMS_V is referenced by following:

SchemaAPPS
Package BodyOKS_AUTO_REMINDER - show dependent code
ViewOKS_BILLPRST_SRVSUBLINE_V
Package BodyOKS_BILL_UTIL_PUB - show dependent code
Package BodyOKS_ENT_UTIL_PVT - show dependent code
Package BodyOKS_MASS_UPD_PVT - show dependent code
Package BodyOKS_OKSCODET_XMLP_PKG - show dependent code
ViewOKS_PROD_DETAILS_V