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

Object Details

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

In OPM Costing, this is where the Burden Percentages are established.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GMF_BURDEN_PERCENTAGES_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	BURDEN_PERCENTAGE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
BURDEN_PERCENTAGE_ID	NUMBER	(10)	Yes	Burden percentage surrogate id
CALENDAR_CODE	VARCHAR2	(4)		Calendar code for which burden code is defined
PERIOD_CODE	VARCHAR2	(4)		Period for which percentage burden is defined
COST_MTHD_CODE	VARCHAR2	(4)		Cost method code for which burden percentage is defined
BURDEN_ID	NUMBER	(10)	Yes	Burden code surrogate id
ORGN_CODE	VARCHAR2	(4)		Organization code
WHSE_CODE	VARCHAR2	(4)		Warehouse code
ITEM_ID	NUMBER	(10)		Item surrogate id
ICGL_CLASS	VARCHAR2	(8)		Item GL class (of type SSPL)
ITEMCOST_CLASS	VARCHAR2	(8)		Item cost class
GL_PROD_LINE	VARCHAR2	(8)		GL product line
GL_BUSINESS_CLASS	VARCHAR2	(8)		GL business class
SSPL_CLASS	VARCHAR2	(8)		SSPL class
PERCENTAGE	NUMBER		Yes	Actual burden percentage
CREATED_BY	NUMBER	(15)	Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
DELETE_MARK	NUMBER	(5)	Yes	Standard delete mark
GL_BUSINESS_CATEGORY_ID	NUMBER			Category Id for GL_BUSINESS_CLASS
GL_CATEGORY_ID	NUMBER			Category Id for GL_CLASS
COST_CATEGORY_ID	NUMBER			Category Id for COST_CLASS
SSPL_CATEGORY_ID	NUMBER			Category Id for SSPL_CLASS
GL_PROD_LINE_CATEGORY_ID	NUMBER	(5)		Category ID for Product Line category
COST_TYPE_ID	NUMBER	(15)		cost type identifier
INVENTORY_ITEM_ID	NUMBER	(15)		inventory item identifier
ORGANIZATION_ID	NUMBER	(15)		organization identifier
PERIOD_ID	NUMBER	(15)		period identifier
MASTER_ORGANIZATION_ID	NUMBER	(15)		Master Organization identifier for item validation
LEGAL_ENTITY_ID	NUMBER	(15)		legal entity identifier

Query Text

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


SELECT BURDEN_PERCENTAGE_ID
,      CALENDAR_CODE
,      PERIOD_CODE
,      COST_MTHD_CODE
,      BURDEN_ID
,      ORGN_CODE
,      WHSE_CODE
,      ITEM_ID
,      ICGL_CLASS
,      ITEMCOST_CLASS
,      GL_PROD_LINE
,      GL_BUSINESS_CLASS
,      SSPL_CLASS
,      PERCENTAGE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      DELETE_MARK
,      GL_BUSINESS_CATEGORY_ID
,      GL_CATEGORY_ID
,      COST_CATEGORY_ID
,      SSPL_CATEGORY_ID
,      GL_PROD_LINE_CATEGORY_ID
,      COST_TYPE_ID
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      PERIOD_ID
,      MASTER_ORGANIZATION_ID
,      LEGAL_ENTITY_ID
FROM GMF.GMF_BURDEN_PERCENTAGES;

Dependencies

[top of page]

GMF.GMF_BURDEN_PERCENTAGES does not reference any database object

GMF.GMF_BURDEN_PERCENTAGES is referenced by following:

APPS: GMF_BURDEN_PERCENTAGES