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_BAS

Object Details

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

This table contains the basis information for an allocation code
about the items to which expenses will be allocated, the allocation
criteria based upon the basis account or fixed percent, and the cost
component class bucket to which the allocated cost will go.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GL_ALOC_BAS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	ALLOC_ID LINE_NO

Columns

Name	Datatype	Length	Mandatory	Comments
ALLOC_ID	NUMBER	(10)	Yes	Allocation Code identifier
LINE_NO	NUMBER	(10)	Yes	Line number
ALLOC_METHOD	NUMBER	(5)	Yes	Indicator for allocation method. 0 = Alloc Percent Depends on Basis Amount; 1 = Fixed Percent is Used for Allocation. Note that alloc_method will have same value for all lines of an alloc_id
ITEM_ID	NUMBER	(10)		Item to which allocation will be done
BASIS_ACCOUNT_KEY	VARCHAR2	(255)		The basis account used to compute the allocation percentage. This will have a value only for alloc_method = 0.
BASIS_ACCOUNT_DESC	VARCHAR2	(70)		The basis account description
BALANCE_TYPE	NUMBER	(10)		Indicator for the type of the basis account. Only for alloc_method = 0. 0 = Statistical; 1 = Budget; 2 = Actual
BAS_YTD_PTD	NUMBER	(10)		YTP/PTD Indicator. Determines which amount to use to compute the allocation %age. Only for alloc_method = 0. 0 = Use Period to Date Basis Amount; 1 = Use Year to Date Basis Amount
FIXED_PERCENT	NUMBER			Indicate fixed allocation %age. Only for alloc_method = 1.
CMPNTCLS_ID	NUMBER	(10)	Yes	surrogate for the component class assigned to the cost from expense.
ANALYSIS_CODE	VARCHAR2	(4)	Yes	Analysis code assigned to the cost from the expense.
WHSE_CODE	VARCHAR2	(4)		The whse to which the cost will be allocated.
CREATION_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
TRANS_CNT	NUMBER	(10)		Not currently used
TEXT_CODE	NUMBER	(10)		ID which joins any rows of text in this table to the Text Table for this Module
DELETE_MARK	NUMBER	(5)	Yes	Standard: 0=Active record (default); 1=Marked for (logical) deletion.
BASIS_ACCOUNT_ID	NUMBER	(15)		basis account code combination id
BASIS_TYPE	NUMBER	(2)		basis type
INVENTORY_ITEM_ID	NUMBER	(15)		inventory item identifier
ORGANIZATION_ID	NUMBER	(15)		organization identifier

Query Text

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


SELECT ALLOC_ID
,      LINE_NO
,      ALLOC_METHOD
,      ITEM_ID
,      BASIS_ACCOUNT_KEY
,      BASIS_ACCOUNT_DESC
,      BALANCE_TYPE
,      BAS_YTD_PTD
,      FIXED_PERCENT
,      CMPNTCLS_ID
,      ANALYSIS_CODE
,      WHSE_CODE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      TRANS_CNT
,      TEXT_CODE
,      DELETE_MARK
,      BASIS_ACCOUNT_ID
,      BASIS_TYPE
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
FROM GMF.GL_ALOC_BAS;

Dependencies

[top of page]

GMF.GL_ALOC_BAS does not reference any database object

GMF.GL_ALOC_BAS is referenced by following:

APPS: GL_ALOC_BAS