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: GMF.GL_ALOC_DTL

Object Details

Object Name:	GL_ALOC_DTL
Object Type:	TABLE
Owner:	GMF
FND Design Data:	GMF.GL_ALOC_DTL
Subobject Name:
Status:	VALID

This table contains the result of the allocation processing. The
actual costing will use this table to determine the expense
allocation for the items.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GL_ALOC_DTLI1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ALLOCDTL_ID
GL_ALOC_DTL_PK	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PERIOD_ID COST_TYPE_ID ALLOC_ID LINE_NO

Columns

Name	Datatype	Length	Mandatory	Comments
CALENDAR_CODE	VARCHAR2	(10)		Cost Calendar code
PERIOD	VARCHAR2	(10)		Cost Period code
ALLOC_ID	NUMBER	(10)	Yes	Allocation identifier
LINE_NO	NUMBER	(10)	Yes	Allocation line
ALLOCDTL_ID	NUMBER	(10)	Yes	Surrogate identifying this row
PERCENT_ALLOCATION	NUMBER		Yes	Allocation Percent. Only for basis lines.
ALLOCATED_EXPENSE_AMT	NUMBER		Yes	Allocated Expense. Only for the basis lines.
AC_STATUS	NUMBER	(5)	Yes	Indicates if expenses are applied by the Actual Cost Process: 0-Not Applied. 1-Applied; 2-Modified
CREATION_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
TRANS_CNT	NUMBER	(10)		Not currently used
DELETE_MARK	NUMBER	(5)	Yes	Standard: 0=Active record (default); 1=Marked for (logical) deletion.
TEXT_CODE	NUMBER	(10)		ID which joins any rows of text in this table to the Text Table for this Module
REQUEST_ID	NUMBER	(15)		Concurrent who column
PROGRAM_APPLICATION_ID	NUMBER	(15)		Concurrent who column
PROGRAM_ID	NUMBER	(15)		Concurrent who column
PROGRAM_UPDATE_DATE	DATE			Concurrent who column
COST_TYPE_ID	NUMBER	(15)		cost type identifier
PERIOD_ID	NUMBER	(15)		Period identifier
PERIOD_QTY	NUMBER			Period quantity over which expenses are apportioned
TOTAL_QTY	NUMBER			Total quantity used for unit cost computation
GL_POSTED_IND	NUMBER	(5)		This is the gl posted indicator

Query Text

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


SELECT CALENDAR_CODE
,      PERIOD
,      ALLOC_ID
,      LINE_NO
,      ALLOCDTL_ID
,      PERCENT_ALLOCATION
,      ALLOCATED_EXPENSE_AMT
,      AC_STATUS
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      TRANS_CNT
,      DELETE_MARK
,      TEXT_CODE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      COST_TYPE_ID
,      PERIOD_ID
,      PERIOD_QTY
,      TOTAL_QTY
,      GL_POSTED_IND
FROM GMF.GL_ALOC_DTL;

Dependencies

[top of page]

GMF.GL_ALOC_DTL does not reference any database object

GMF.GL_ALOC_DTL is referenced by following:

APPS: GL_ALOC_DTL