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

Object Details

Object Name:	XLA_ACCT_PROG_SEQ_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	XLA.XLA_ACCT_PROG_SEQ_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

This view is used in assigning the completion based sequence numbers to the journal entries generated during a run of accounting program.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
AE_HEADER_ID	NUMBER	(15)	Yes	Accounting entry id
LEDGER_ID	NUMBER	(15)	Yes	Ledger id
BALANCE_TYPE_CODE	VARCHAR2	(1)	Yes	Balance type (Actual, Budget, or Encumbrance)
JE_SOURCE_NAME	VARCHAR2	(30)	Yes	General Ledger source name
JE_CATEGORY_NAME	VARCHAR2	(30)	Yes	General Ledger category name
DOC_CATEGORY_CODE	VARCHAR2	(30)		Document sequence category category code. It used as part of the subledger journal entry sequencing criteria.
ACCOUNTING_EVENT_TYPE_CODE	VARCHAR2	(30)	Yes	Event type code
ACCOUNTING_ENTRY_TYPE_CODE	VARCHAR2	(30)	Yes	Accounting entry type code
GL_DATE	DATE		Yes	Accounting date
COMPLETION_DATE	DATE			Subledger journal entry completion date
COMPLETION_ACCT_SEQ_ASSIGN_ID	NUMBER	(15)		Journal entry completion sequence assignment identifier
COMPLETION_ACCT_SEQ_VERSION_ID	NUMBER	(15)		Subledger journal entry creation sequence Identifier
COMPLETION_ACCT_SEQ_VALUE	NUMBER			Subledger journal entry creation sequence Value
APPLICATION_ID	NUMBER	(15)	Yes	Internal Id of the application

Query Text

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


SELECT AE_HEADER_ID
,      LEDGER_ID
,      BALANCE_TYPE_CODE
,      JE_SOURCE_NAME
,      JE_CATEGORY_NAME
,      DOC_CATEGORY_CODE
,      ACCOUNTING_EVENT_TYPE_CODE
,      ACCOUNTING_ENTRY_TYPE_CODE
,      GL_DATE
,      COMPLETION_DATE
,      COMPLETION_ACCT_SEQ_ASSIGN_ID
,      COMPLETION_ACCT_SEQ_VERSION_ID
,      COMPLETION_ACCT_SEQ_VALUE
,      APPLICATION_ID
FROM APPS.XLA_ACCT_PROG_SEQ_V;

Dependencies

[top of page]

APPS.XLA_ACCT_PROG_SEQ_V references the following:

APPS: XLA_AE_HEADERS; XLA_EVENTS_GT; XLA_SUBLEDGERS

APPS.XLA_ACCT_PROG_SEQ_V is referenced by following:

APPS: FUN_SEQ_BATCH - show dependent code