eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.OKL_CMN_EXTRACT_LINE_V

Object Details

Object Name:	OKL_CMN_EXTRACT_LINE_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKL.OKL_CMN_EXTRACT_LINE_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
EVENT_ID	NUMBER			not used
LINE_NUMBER	NUMBER		Yes	Primary key column
DIST_ID	NUMBER		Yes	Primary key column
DIST_ACCOUNTED_AMOUNT	NUMBER			Distribution amount in functional currency
DIST_AE_LINE_TYPE_CODE	VARCHAR2	(30)		Accounting event line type
DIST_CODE_COMBINATION_ID	NUMBER			Key flexfield combination defining column
DIST_CR_DR_FLAG	VARCHAR2	(30)		Debit Credit Flag. Values are 'C' or 'D'
DIST_ENTERED_AMOUNT	NUMBER			Amount
DIST_GL_DATE	DATE			General ledger date
DIST_ORIGINAL_DISTRIBUTION_ID	NUMBER			Original Distribution identifier. This field contains the identifier of the original distribution for which this is a reversal distribution. This field is used by accounting reversal process.
DIST_POST_TO_GL_FLAG	VARCHAR2	(30)		This flag indicates if the distribution should be posted to GL or not. Possible values are 'Y' or 'N'. Only those distributions which have this flag as 'Y' are transferred to subledger accounting tables
DIST_TYPE	CHAR	(18)
TCL_ID	NUMBER		Yes
TEL_LINE_EXTENSION_ID	NUMBER
TCL_TAX_LINE_ID	NUMBER
TCL_STY_ID	NUMBER
DIST_ACCOUNTING_TEMPLATE_NAME	VARCHAR2	(150)
TCL_AMOUNT	NUMBER
TCL_CURRENCY_CODE	VARCHAR2	(150)
TCL_DESCRIPTION	VARCHAR2	(1995)
TCL_TCN_ID	NUMBER		Yes
TCL_TYPE	VARCHAR2	(10)	Yes
TEL_MEMO_FLAG	VARCHAR2	(3)
LEDGER_ID	NUMBER		Yes
TCL_STREAM_TYPE_CODE	VARCHAR2	(150)		Stream Type Code
TCL_STREAM_TYPE_PURPOSE	VARCHAR2	(240)		Stream Type Purpose
TEL_INVENTORY_ORG_CODE	VARCHAR2	(240)		Inventory Organization Code

Query Text

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


SELECT EVENT_ID
,      LINE_NUMBER
,      DIST_ID
,      DIST_ACCOUNTED_AMOUNT
,      DIST_AE_LINE_TYPE_CODE
,      DIST_CODE_COMBINATION_ID
,      DIST_CR_DR_FLAG
,      DIST_ENTERED_AMOUNT
,      DIST_GL_DATE
,      DIST_ORIGINAL_DISTRIBUTION_ID
,      DIST_POST_TO_GL_FLAG
,      DIST_TYPE
,      TCL_ID
,      TEL_LINE_EXTENSION_ID
,      TCL_TAX_LINE_ID
,      TCL_STY_ID
,      DIST_ACCOUNTING_TEMPLATE_NAME
,      TCL_AMOUNT
,      TCL_CURRENCY_CODE
,      TCL_DESCRIPTION
,      TCL_TCN_ID
,      TCL_TYPE
,      TEL_MEMO_FLAG
,      LEDGER_ID
,      TCL_STREAM_TYPE_CODE
,      TCL_STREAM_TYPE_PURPOSE
,      TEL_INVENTORY_ORG_CODE
FROM APPS.OKL_CMN_EXTRACT_LINE_V;

Dependencies

[top of page]

APPS.OKL_CMN_EXTRACT_LINE_V references the following:

APPS: OKL_TRNS_ACC_DSTRS_ALL; OKL_TXL_CNTRCT_LNS_ALL; OKL_TXL_EXTENSION_B

APPS.OKL_CMN_EXTRACT_LINE_V is referenced by following:

APPS: XLA_00540_AAD_S_000014_PKG - show dependent code