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


VIEW: APPS.OKL_CS_VENDORS_UV

Object Details
Object Name: OKL_CS_VENDORS_UV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_CS_VENDORS_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 CHAR (0)
PTYPE VARCHAR2 (0)
COMPANY VARCHAR2 (240)
CUSTOMER_NUMBER VARCHAR2 (30) Yes
EMAIL VARCHAR2 (2000)
PHONE VARCHAR2 (26)
ADDRESS1 VARCHAR2 (240)
ADDRESS2 VARCHAR2 (240)
ADDRESS3 VARCHAR2 (240)
ADDRESS4 VARCHAR2 (240)
CITY VARCHAR2 (60)
COUNTY VARCHAR2 (60)
PROVINCE VARCHAR2 (60)
STATE VARCHAR2 (60)
POSTAL_CODE VARCHAR2 (20)
COUNTRY VARCHAR2 (25)
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_VENDORS_UV;

Dependencies

[top of page]

APPS.OKL_CS_VENDORS_UV references the following:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymOKC_K_HEADERS_B
ViewOKC_K_PARTY_ROLES_V
ViewPO_VENDORS
ViewPO_VENDOR_SITES_ALL
APPS.OKL_CS_VENDORS_UV is referenced by following:

SchemaAPPS
ViewOKL_CS_ALL_PARTIES_W_AMOUNT_UV
ViewOKL_CS_PARTIES_TAB_UV