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


VIEW: APPS.OKL_CS_CONT_SRCH_RESULTS_UV

Object Details
Object Name: OKL_CS_CONT_SRCH_RESULTS_UV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_CS_CONT_SRCH_RESULTS_UV
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
CONTRACT_ID NUMBER
Yes
CONTRACT_NUMBER VARCHAR2 (120) Yes Contract Number
PARTY_NAME VARCHAR2 (360) Yes
ALTERNATE_NAME VARCHAR2 (320)
PRODUCT_TYPE VARCHAR2 (150) Yes
STATUS VARCHAR2 (90) Yes Status
SHORT_DESCRIPTION VARCHAR2 (1995)
PRIVATE_LABEL VARCHAR2 (0)
START_DATE DATE

Start Date
END_DATE DATE

End Date
ACCOUNT VARCHAR2 (30) Yes
OBJECT_CODE CHAR (12)
ORG_ID NUMBER
Yes Operating Unit Identifier
OPERATING_UNIT VARCHAR2 (240) Yes Operating Unit
Query Text

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


SELECT CONTRACT_ID
,      CONTRACT_NUMBER
,      PARTY_NAME
,      ALTERNATE_NAME
,      PRODUCT_TYPE
,      STATUS
,      SHORT_DESCRIPTION
,      PRIVATE_LABEL
,      START_DATE
,      END_DATE
,      ACCOUNT
,      OBJECT_CODE
,      ORG_ID
,      OPERATING_UNIT
FROM APPS.OKL_CS_CONT_SRCH_RESULTS_UV;

Dependencies

[top of page]

APPS.OKL_CS_CONT_SRCH_RESULTS_UV references the following:

SchemaAPPS
ViewHR_OPERATING_UNITS
SynonymHZ_CUST_ACCOUNTS
SynonymHZ_PARTIES
ViewOKC_K_HEADERS_V
ViewOKC_STATUSES_V
PL/SQL PackageOKC_UTIL - show dependent code
SynonymOKL_K_HEADERS
SynonymOKL_PRODUCTS

APPS.OKL_CS_CONT_SRCH_RESULTS_UV is not referenced by any database object