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


VIEW: APPS.OKL_CUSTOMER_ACCT_UV

Object Details
Object Name: OKL_CUSTOMER_ACCT_UV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_CUSTOMER_ACCT_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
CUSTOMER_ID1 NUMBER (15) Yes
CUSTOMER_ID2 CHAR (1)
CUSTOMER_NUMBER VARCHAR2 (30) Yes
CUSTOMER_NAME VARCHAR2 (360) Yes
CUSTOMER_JTOT_OBJECT_CODE VARCHAR2 (30) Yes
CUST_ACCT_ID NUMBER (15) Yes
CUST_ACCT_NUMBER VARCHAR2 (30) Yes
CUST_ACCT_NAME VARCHAR2 (360)
LEGAL_ADDRESS VARCHAR2 (4000)
PARTY_ID NUMBER (15) Yes
CUST_ACCT_STATUS VARCHAR2 (1) Yes
Query Text

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


SELECT CUSTOMER_ID1
,      CUSTOMER_ID2
,      CUSTOMER_NUMBER
,      CUSTOMER_NAME
,      CUSTOMER_JTOT_OBJECT_CODE
,      CUST_ACCT_ID
,      CUST_ACCT_NUMBER
,      CUST_ACCT_NAME
,      LEGAL_ADDRESS
,      PARTY_ID
,      CUST_ACCT_STATUS
FROM APPS.OKL_CUSTOMER_ACCT_UV;

Dependencies

[top of page]

APPS.OKL_CUSTOMER_ACCT_UV references the following:

SchemaAPPS
PL/SQL PackageARP_ADDR_LABEL_PKG - show dependent code
SynonymOKC_ROLE_SOURCES
ViewOKX_CUSTOMER_ACCOUNTS_V
ViewOKX_CUST_SITE_USES_V
ViewOKX_PARTIES_V

APPS.OKL_CUSTOMER_ACCT_UV is not referenced by any database object