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: GL.GL_RECURRING_BATCHES

Object Details

Object Name:	GL_RECURRING_BATCHES
Object Type:	TABLE
Owner:	GL
FND Design Data:	SQLGL.GL_RECURRING_BATCHES
Subobject Name:
Status:	VALID

GL_RECURRING_BATCHES stores your journal entry formula batches and your budget formula batches. Each row includes the batch name, description, and other information. This table corresponds to the Recurring Batch section of the Define Recurring Journal Formula form and the Define Budget Formula form. BUDGET_FLAG is 'Y' for a budget formula batch and 'N' for a journal entry formula batch.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GL_RECURRING_BATCHES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	RECURRING_BATCH_ID
GL_RECURRING_BATCHES_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	NAME CHART_OF_ACCOUNTS_ID PERIOD_SET_NAME ACCOUNTED_PERIOD_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
RECURRING_BATCH_ID	NUMBER	(15)	Yes	Recurring journal batch defining column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LEDGER_ID	NUMBER	(15)		Ledger defining column
NAME	VARCHAR2	(30)	Yes	Recurring journal batch name
BUDGET_FLAG	VARCHAR2	(1)	Yes	Recurring budget journal batch flag
ALLOCATION_FLAG	VARCHAR2	(1)	Yes	No longer used(default = 'Y')
CREATION_DATE	DATE			Standard Who column
CREATED_BY	NUMBER	(15)		Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
BUDGET_IN_FORMULA_FLAG	VARCHAR2	(1)		Budget balances used in recurring journal entry formulas flag
DESCRIPTION	VARCHAR2	(240)		Recurring journal batch description
PERIOD_TYPE	VARCHAR2	(15)		Accounting period type
LAST_EXECUTED_PERIOD_NAME	VARCHAR2	(15)		Period in which this batch last executed
LAST_EXECUTED_DATE	DATE			Date on which this batch last executed
LAST_EXEC_JOURNAL_DATE	DATE			Journal effective date for which this batch was last executed
LAST_EXEC_CALCULATION_DATE	DATE			Calculation effective date for which this batch was last executed
LAST_EXEC_BUDGET_VERSION_ID	NUMBER	(15)		Budget for which this batch was last executed
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
CONTEXT	VARCHAR2	(150)		Descriptive flexfield context
SECURITY_FLAG	VARCHAR2	(1)	Yes	Enable definition access set security flag
RECURRING_BATCH_TYPE	VARCHAR2	(1)	Yes	Recurring batch type
CHART_OF_ACCOUNTS_ID	NUMBER	(15)	Yes	Key flexfield structure defining column
PERIOD_SET_NAME	VARCHAR2	(15)	Yes	Accounting calendar name
ACCOUNTED_PERIOD_TYPE	VARCHAR2	(15)	Yes	Accounting period type

Query Text

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


SELECT RECURRING_BATCH_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LEDGER_ID
,      NAME
,      BUDGET_FLAG
,      ALLOCATION_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      BUDGET_IN_FORMULA_FLAG
,      DESCRIPTION
,      PERIOD_TYPE
,      LAST_EXECUTED_PERIOD_NAME
,      LAST_EXECUTED_DATE
,      LAST_EXEC_JOURNAL_DATE
,      LAST_EXEC_CALCULATION_DATE
,      LAST_EXEC_BUDGET_VERSION_ID
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      CONTEXT
,      SECURITY_FLAG
,      RECURRING_BATCH_TYPE
,      CHART_OF_ACCOUNTS_ID
,      PERIOD_SET_NAME
,      ACCOUNTED_PERIOD_TYPE
FROM GL.GL_RECURRING_BATCHES;

Dependencies

[top of page]

GL.GL_RECURRING_BATCHES does not reference any database object

GL.GL_RECURRING_BATCHES is referenced by following:

APPS: GL_RECURRING_BATCHES