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

TABLE: OKI.OKI_QTO

Object Details
Object Name: OKI_QTO
Object Type: TABLE
Owner: OKI
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: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OKI_QTO_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCHR_ID
Columns
Name Datatype Length Mandatory Comments
CONTRACT_NUMBER VARCHAR2 (120)
Contract number
CONTRACT_NUMBER_MODIFIER VARCHAR2 (120)
Contract number modifier
COMPLETE_CONTRACT_NUMBER VARCHAR2 (240)
Complete contract number
CHR_ID NUMBER
Yes Contract header id
CONTACT_ID NUMBER

Contact id
SITE_ID NUMBER

Site id
PARTY_ID NUMBER

Party id
CUST_ID NUMBER

Customer id
EMAIL_ID NUMBER

Email id
PHONE_ID NUMBER

Phone id
FAX_ID NUMBER

Fax id
CUST_NAME VARCHAR2 (1000)
Customer name
CONTACT VARCHAR2 (120)
Contact name
EMAIL VARCHAR2 (2000)
Email
PHONE VARCHAR2 (120)
Phone number
FAX VARCHAR2 (120)
fax Number
ADDRESS VARCHAR2 (120)
Address
CREATION_DATE DATE

standard who column
LAST_UPDATE_DATE DATE

standard who column
SECURITY_GROUP_ID NUMBER

Used for application hosting.
Query Text

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


SELECT CONTRACT_NUMBER
,      CONTRACT_NUMBER_MODIFIER
,      COMPLETE_CONTRACT_NUMBER
,      CHR_ID
,      CONTACT_ID
,      SITE_ID
,      PARTY_ID
,      CUST_ID
,      EMAIL_ID
,      PHONE_ID
,      FAX_ID
,      CUST_NAME
,      CONTACT
,      EMAIL
,      PHONE
,      FAX
,      ADDRESS
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      SECURITY_GROUP_ID
FROM OKI.OKI_QTO;

Dependencies

[top of page]

OKI.OKI_QTO does not reference any database object

OKI.OKI_QTO is referenced by following:

SchemaAPPS
SynonymOKI_QTO