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

VIEW: APPS.OKL_CS_ALL_PARTIES_W_AMOUNT_UV

Object Details
Object Name: OKL_CS_ALL_PARTIES_W_AMOUNT_UV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_CS_ALL_PARTIES_W_AMOUNT_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

CONTRACT_NUMBER VARCHAR2 (120)
Contract Number
ROLE_NAME VARCHAR2 (80)
AMT_GUARANTEED VARCHAR2 (450)
PTYPE VARCHAR2 (150)
COMPANY VARCHAR2 (360)
CUSTOMER_NUMBER VARCHAR2 (30)
EMAIL VARCHAR2 (2000)
PHONE VARCHAR2 (62)
ADDRESS1 VARCHAR2 (240)
ADDRESS2 VARCHAR2 (240)
ADDRESS3 VARCHAR2 (240)
ADDRESS4 VARCHAR2 (240)
CITY VARCHAR2 (60)
COUNTY VARCHAR2 (60)
PROVINCE VARCHAR2 (60)
STATE VARCHAR2 (120)
POSTAL_CODE VARCHAR2 (60)
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_ALL_PARTIES_W_AMOUNT_UV;

Dependencies

[top of page]

APPS.OKL_CS_ALL_PARTIES_W_AMOUNT_UV references the following:

SchemaAPPS
PL/SQL PackageARP_ADDR_LABEL_PKG - show dependent code
PL/SQL PackageFND_GLOBAL - show dependent code
PL/SQL PackageHR_GENERAL - show dependent code
ViewOKL_CS_ALL_PARTIES_UV
ViewOKL_CS_GUARANTOR_AMOUNT_UV
ViewOKL_CS_LESSOR_UV
ViewOKL_CS_VENDORS_UV

APPS.OKL_CS_ALL_PARTIES_W_AMOUNT_UV is not referenced by any database object