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

VIEW: APPS.OKI_QTO_V

Object Details
Object Name: OKI_QTO_V
Object Type: VIEW
Owner: APPS
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
CONTRACT_ID NUMBER
Yes Contract id
CONTRACT_NUMBER VARCHAR2 (120)
Contract number
CONTRACT_NUMBER_MODIFIER VARCHAR2 (120)
Contract number modifier
COMPLETE_CONTRACT_NUMBER VARCHAR2 (241)
Complete contract number
CONTACT_ID NUMBER

Contact id
SITE_ID NUMBER

Site id
PARTY_ID NUMBER (15) Yes Party id
CUST_ID NUMBER (15) Yes Customer id
EMAIL_ID NUMBER

Email id
PHONE_ID NUMBER

Phone id
FAX_ID NUMBER

Fax id
CUST_NAME VARCHAR2 (360) Yes Customer name
CONTACT VARCHAR2 (120)
Contact name
EMAIL VARCHAR2 (2000)
Email
PHONE VARCHAR2 (40)
Phone
FAX VARCHAR2 (40)
Fax
ADDRESS VARCHAR2 (80)
Address
CREATION_DATE DATE

standard who column
LAST_UPDATE_DATE DATE

standard who column
Query Text

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


SELECT CONTRACT_ID
,      CONTRACT_NUMBER
,      CONTRACT_NUMBER_MODIFIER
,      COMPLETE_CONTRACT_NUMBER
,      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
FROM APPS.OKI_QTO_V;

Dependencies

[top of page]

APPS.OKI_QTO_V references the following:

SchemaAPPS
PL/SQL PackageARP_ADDR_LABEL_PKG - show dependent code
SynonymHZ_CONTACT_POINTS
SynonymHZ_CUST_ACCOUNTS
SynonymHZ_CUST_ACCOUNT_ROLES
SynonymHZ_CUST_ACCT_SITES_ALL
SynonymHZ_LOCATIONS
SynonymHZ_PARTIES
SynonymHZ_PARTY_SITES
SynonymHZ_RELATIONSHIPS
SynonymOKI_SALES_K_HDRS

APPS.OKI_QTO_V is not referenced by any database object