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

VIEW: APPS.OKL_FA_DIST_UV

Object Details
Object Name: OKL_FA_DIST_UV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_FA_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 VARCHAR2 (72)
Primary key column
AE_LINE_TYPE VARCHAR2 (26)
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 (80)
CR_DR_FLAG VARCHAR2 (2)
DR_CR_FLAG_MEANING VARCHAR2 (4000)
AMOUNT NUMBER

Amount
ACCOUNTING_DATE DATE

TEMPLATE_NAME VARCHAR2 (80)
POSTED VARCHAR2 (4000)
SOURCE_ID VARCHAR2 (113)
SOURCE_TABLE VARCHAR2 (21)
ASSET_ID NUMBER (15)
Asset Identifier
DISTRIBUTION_ID NUMBER (15)
Distribution Identifier
PERIOD_COUNTER NUMBER (15)
Period Counter
BOOK_TYPE_CODE VARCHAR2 (15)
Book Type Code
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
,      ASSET_ID
,      DISTRIBUTION_ID
,      PERIOD_COUNTER
,      BOOK_TYPE_CODE
FROM APPS.OKL_FA_DIST_UV;

Dependencies

[top of page]

APPS.OKL_FA_DIST_UV references the following:

SchemaAPPS
SynonymFA_ADDITIONS
SynonymFA_ADJUSTMENTS
SynonymFA_DEPRN_DETAIL
SynonymFA_DEPRN_PERIODS
SynonymFA_DISTRIBUTION_HISTORY
SynonymFA_LOOKUPS
SynonymFA_TRANSACTION_HEADERS
SynonymGL_JE_LINES
PL/SQL PackageOKL_ACCOUNTING_UTIL - show dependent code

APPS.OKL_FA_DIST_UV is not referenced by any database object