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

VIEW: APPS.OKL_AP_DIST_UV

Object Details
Object Name: OKL_AP_DIST_UV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_AP_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 (11)
INVOICE_ID VARCHAR2 (240)
Invoice Id
CHECK_ID VARCHAR2 (40)
Check 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
,      INVOICE_ID
,      CHECK_ID
FROM APPS.OKL_AP_DIST_UV;

Dependencies

[top of page]

APPS.OKL_AP_DIST_UV references the following:

SchemaAPPS
SynonymAP_ACCOUNTING_EVENTS
SynonymAP_AE_HEADERS
SynonymAP_AE_LINES
SynonymAP_CHECKS
SynonymAP_INVOICES
PL/SQL PackageOKL_ACCOUNTING_UTIL - show dependent code
SynonymOKL_SYS_ACCT_OPTS

APPS.OKL_AP_DIST_UV is not referenced by any database object