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]

TABLE: AP.AP_ENCUMBRANCE_LINES_ALL

Object Details

Object Name:	AP_ENCUMBRANCE_LINES_ALL
Object Type:	TABLE
Owner:	AP
FND Design Data:	SQLAP.AP_ENCUMBRANCE_LINES_ALL
Subobject Name:
Status:	VALID

AP_ENCUMBRANCE_LINES_ALLstores
all encumbrance entries created by Oracle
Payables. It contains one line per encumbrance
entry. An encumbrance line could be created to
encumber a charge, QV, IPV, or ERV, to unencumber
an entry created by PO or to reverse an encumbrance
entry once the charge, QV, IPV, or ERV becomes an
actual. This table is used to transfer encumbrance
over to GL, to view encumbrance entries or to report
on them. It is not updatable through the application.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AP_ENCUMBRANCE_LINES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ENCUMBRANCE_LINE_ID
AP_ENCUMBRANCE_LINES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INVOICE_DISTRIBUTION_ID
AP_ENCUMBRANCE_LINES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	AE_HEADER_ID
AP_ENCUMBRANCE_LINES_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GL_SL_LINK_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ENCUMBRANCE_LINE_ID	NUMBER	(15)	Yes	Encumbrance line identifier
INVOICE_DISTRIBUTION_ID	NUMBER	(15)	Yes	Invoice distribution identifier for invoice distribution associated with encumbrance line
ENCUMBRANCE_LINE_TYPE	VARCHAR2	(30)	Yes	Encumbrance line type. The possible values are CHARGE, QV, IPV or ERV
ACCOUNTING_DATE	DATE		Yes	Accounting date
PERIOD_NAME	VARCHAR2	(15)	Yes	Accounting period name
REVERSAL_FLAG	VARCHAR2	(1)	Yes	Flag indicating whether the current encumbrance line unemcumbers an amount that has become an actual. If the value of the flag is Y, the line is picked up by the Transfer to GL process. Possible values are Y or N
ENCUMBRANCE_TYPE_ID	NUMBER	(15)	Yes	Encumbrance type identifier
CODE_COMBINATION_ID	NUMBER	(15)	Yes	Accounting Flexfield identifier for account against which an encumbrance line was created
ACCOUNTED_DR	NUMBER			Debit amount encumbered
ACCOUNTED_CR	NUMBER			Credit amount encumbered
AE_HEADER_ID	NUMBER	(15)		Accounting entry header identifier for accounting entry header associated with the creation of this encumbrance line. The value will be null for entries created during invoice validation.
GL_SL_LINK_ID	NUMBER	(15)		Identifier used for maintaining audit trail upon transfer of the line to GL
ORG_ID	NUMBER	(15)		Organization identifier
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
REFERENCE1	VARCHAR2	(240)		Journal Import Reference Column
REFERENCE2	VARCHAR2	(240)		Journal Import Reference Column
REFERENCE3	VARCHAR2	(240)		Journal Import Reference Column
REFERENCE4	VARCHAR2	(240)		Journal Import Reference Column
REFERENCE5	VARCHAR2	(240)		Journal Import Reference Column
REFERENCE6	VARCHAR2	(240)		Journal Import Reference Column
REFERENCE7	VARCHAR2	(240)		Journal Import Reference Column
REFERENCE8	VARCHAR2	(240)		Journal Import Reference Column
REFERENCE9	VARCHAR2	(240)		Journal Import Reference Column
REFERENCE10	VARCHAR2	(240)		Journal Import Reference Column
STAT_AMOUNT	NUMBER			Amount for measuring statistical quantities, copied over from associated invoice distribution
SUBLEDGER_DOC_SEQUENCE_ID	NUMBER	(15)		Document sequence identifier from transaction data associated with encumbrance line
SUBLEDGER_DOC_SEQUENCE_VALUE	NUMBER	(15)		Document sequence value from transaction data associated with encumbrance line
PROGRAM_UPDATE_DATE	DATE			Concurrent Program who column - date when a program last updated this row).
PROGRAM_APPLICATION_ID	NUMBER	(15)		Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	NUMBER	(15)		Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
REQUEST_ID	NUMBER	(15)		Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).

Query Text

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


SELECT ENCUMBRANCE_LINE_ID
,      INVOICE_DISTRIBUTION_ID
,      ENCUMBRANCE_LINE_TYPE
,      ACCOUNTING_DATE
,      PERIOD_NAME
,      REVERSAL_FLAG
,      ENCUMBRANCE_TYPE_ID
,      CODE_COMBINATION_ID
,      ACCOUNTED_DR
,      ACCOUNTED_CR
,      AE_HEADER_ID
,      GL_SL_LINK_ID
,      ORG_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REFERENCE1
,      REFERENCE2
,      REFERENCE3
,      REFERENCE4
,      REFERENCE5
,      REFERENCE6
,      REFERENCE7
,      REFERENCE8
,      REFERENCE9
,      REFERENCE10
,      STAT_AMOUNT
,      SUBLEDGER_DOC_SEQUENCE_ID
,      SUBLEDGER_DOC_SEQUENCE_VALUE
,      PROGRAM_UPDATE_DATE
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      REQUEST_ID
FROM AP.AP_ENCUMBRANCE_LINES_ALL;

Dependencies

[top of page]

AP.AP_ENCUMBRANCE_LINES_ALL does not reference any database object

AP.AP_ENCUMBRANCE_LINES_ALL is referenced by following:

AP: AP_ENCUMBRANCE_LINES_ALL#