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

VIEW: APPS.OKL_CS_LESSOR_UV

Object Details
Object Name: OKL_CS_LESSOR_UV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_CS_LESSOR_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
ROLE_NAME VARCHAR2 (80) Yes
AMT_GUARANTEED VARCHAR2 (1)
PTYPE VARCHAR2 (150)
COMPANY VARCHAR2 (240) Yes
CUSTOMER_NUMBER VARCHAR2 (3)
EMAIL VARCHAR2 (0)
PHONE VARCHAR2 (60)
ADDRESS1 VARCHAR2 (240)
ADDRESS2 VARCHAR2 (240)
ADDRESS3 VARCHAR2 (240)
ADDRESS4 VARCHAR2 (0)
CITY VARCHAR2 (30)
COUNTY VARCHAR2 (0)
PROVINCE VARCHAR2 (0)
STATE VARCHAR2 (120)
POSTAL_CODE VARCHAR2 (30)
COUNTRY VARCHAR2 (60)
Query Text

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


SELECT CONTRACT_ID
,      CONTRACT_NUMBER
,      ROLE_NAME
,      AMT_GUARANTEED
,      PTYPE
,      COMPANY
,      CUSTOMER_NUMBER
,      EMAIL
,      PHONE
,      ADDRESS1
,      ADDRESS2
,      ADDRESS3
,      ADDRESS4
,      CITY
,      COUNTY
,      PROVINCE
,      STATE
,      POSTAL_CODE
,      COUNTRY
FROM APPS.OKL_CS_LESSOR_UV;

Dependencies

[top of page]

APPS.OKL_CS_LESSOR_UV references the following:

SchemaAPPS
PL/SQL PackageARP_ADDR_LABEL_PKG - show dependent code
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymHR_ALL_ORGANIZATION_UNITS
PL/SQL PackageHR_GENERAL - show dependent code
ViewHR_LOCATIONS
SynonymOKC_K_HEADERS_B
ViewOKC_K_PARTY_ROLES_V
ViewOKX_ORGANIZATION_DEFS_V
APPS.OKL_CS_LESSOR_UV is referenced by following:

SchemaAPPS
ViewOKL_CS_ALL_PARTIES_W_AMOUNT_UV
ViewOKL_CS_PARTIES_TAB_UV