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

VIEW: APPS.OKL_AR_DIST_UV

Object Details
Object Name: OKL_AR_DIST_UV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_AR_DIST_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
ID NUMBER (15)
Primary key column
AE_LINE_TYPE VARCHAR2 (30)
Accounting event line type
CODE_COMBINATION_ID NUMBER (15)
Key flexfield combination defining column
CONCATE_SEGMENTS VARCHAR2 (4000)
CONCATE_SEGMENTS_DESC VARCHAR2 (4000)
AE_LINE_TYPE_MEANING VARCHAR2 (4000)
CR_DR_FLAG VARCHAR2 (1)
DR_CR_FLAG_MEANING VARCHAR2 (4000)
AMOUNT NUMBER

Amount
ACCOUNTING_DATE DATE

TEMPLATE_NAME VARCHAR2 (4000)
POSTED VARCHAR2 (4000)
SOURCE_ID NUMBER (15)
SOURCE_TABLE VARCHAR2 (21)
CUSTOMER_TRX_ID NUMBER

Customer Trx Id
Query Text

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


SELECT ID
,      AE_LINE_TYPE
,      CODE_COMBINATION_ID
,      CONCATE_SEGMENTS
,      CONCATE_SEGMENTS_DESC
,      AE_LINE_TYPE_MEANING
,      CR_DR_FLAG
,      DR_CR_FLAG_MEANING
,      AMOUNT
,      ACCOUNTING_DATE
,      TEMPLATE_NAME
,      POSTED
,      SOURCE_ID
,      SOURCE_TABLE
,      CUSTOMER_TRX_ID
FROM APPS.OKL_AR_DIST_UV;

Dependencies

[top of page]

APPS.OKL_AR_DIST_UV references the following:

SchemaAPPS
SynonymAR_CASH_RECEIPT_HISTORY
SynonymAR_DISTRIBUTIONS
SynonymAR_PAYMENT_SCHEDULES
SynonymAR_RECEIVABLE_APPLICATIONS
PL/SQL PackageOKL_ACCOUNTING_UTIL - show dependent code
SynonymRA_CUSTOMER_TRX
SynonymRA_CUST_TRX_LINE_GL_DIST
SynonymRA_CUST_TRX_TYPES

APPS.OKL_AR_DIST_UV is not referenced by any database object