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.AP_ENCUMBRANCE_LINES_V

Object Details

Object Name:	AP_ENCUMBRANCE_LINES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	SQLAP.AP_ENCUMBRANCE_LINES_V
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
ROW_ID	ROWID	(10)
ENCUMBRANCE_LINE_ID	NUMBER	(15)	Yes
ENCUMBRANCE_TYPE	VARCHAR2	(30)	Yes
LINE_TYPE	VARCHAR2	(80)	Yes
CODE_COMBINATION_ID	NUMBER	(15)	Yes
DEBIT_AMOUNT	NUMBER
CREDIT_AMOUNT	NUMBER
PERIOD	VARCHAR2	(15)	Yes
ACCOUNTING_DATE	DATE		Yes
REVERSAL	VARCHAR2	(1)	Yes
INVOICE_ID	NUMBER	(15)	Yes
INVOICE_NUM	VARCHAR2	(50)	Yes
INVOICE_DISTRIBUTION_ID	NUMBER	(15)	Yes
DIST_LINE_NUM	NUMBER	(15)	Yes
DIST_DESC	VARCHAR2	(240)

Query Text

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


SELECT ROW_ID
,      ENCUMBRANCE_LINE_ID
,      ENCUMBRANCE_TYPE
,      LINE_TYPE
,      CODE_COMBINATION_ID
,      DEBIT_AMOUNT
,      CREDIT_AMOUNT
,      PERIOD
,      ACCOUNTING_DATE
,      REVERSAL
,      INVOICE_ID
,      INVOICE_NUM
,      INVOICE_DISTRIBUTION_ID
,      DIST_LINE_NUM
,      DIST_DESC
FROM APPS.AP_ENCUMBRANCE_LINES_V;

Dependencies

[top of page]

APPS.AP_ENCUMBRANCE_LINES_V references the following:

APPS: AP_ENCUMBRANCE_LINES; AP_INVOICES; AP_INVOICE_DISTRIBUTIONS; AP_LOOKUP_CODES; FND_GLOBAL - show dependent code; GL_ENCUMBRANCE_TYPES

APPS.AP_ENCUMBRANCE_LINES_V is not referenced by any database object