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

VIEW: APPS.OKL_CS_GUARANTOR_AMOUNT_UV

Object Details
Object Name: OKL_CS_GUARANTOR_AMOUNT_UV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_CS_GUARANTOR_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
Yes
CONTRACT_NUMBER VARCHAR2 (120) Yes Contract Number
ROLE_NAME VARCHAR2 (30) Yes
AMOUNT_GUARANTEED VARCHAR2 (450)
PARTY_TYPE VARCHAR2 (30) Yes
COMPANY VARCHAR2 (360) Yes
CUSTOMER_NUMBER VARCHAR2 (30) Yes
EMAIL VARCHAR2 (2000)
RAW_PHONE_NUMBER 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 (60)
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
,      AMOUNT_GUARANTEED
,      PARTY_TYPE
,      COMPANY
,      CUSTOMER_NUMBER
,      EMAIL
,      RAW_PHONE_NUMBER
,      ADDRESS1
,      ADDRESS2
,      ADDRESS3
,      ADDRESS4
,      CITY
,      COUNTY
,      PROVINCE
,      STATE
,      POSTAL_CODE
,      COUNTRY
FROM APPS.OKL_CS_GUARANTOR_AMOUNT_UV;

Dependencies

[top of page]

APPS.OKL_CS_GUARANTOR_AMOUNT_UV references the following:

SchemaAPPS
SynonymHZ_CONTACT_POINTS
SynonymHZ_PARTIES
SynonymOKC_K_HEADERS_B
SynonymOKC_K_PARTY_ROLES_B
SynonymOKC_RG_PARTY_ROLES
SynonymOKC_RG_ROLE_DEFS
SynonymOKC_RULES_B
SynonymOKC_RULE_GROUPS_B
SynonymOKC_SUBCLASS_RG_DEFS
SynonymOKC_SUBCLASS_ROLES
APPS.OKL_CS_GUARANTOR_AMOUNT_UV is referenced by following:

SchemaAPPS
ViewOKL_CS_ALL_PARTIES_W_AMOUNT_UV
ViewOKL_CS_NON_VENDORS_UV
ViewOKL_CS_PARTIES_TAB_UV