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: BOM.CST_COST_GROUP_ACCOUNTS

Object Details

Object Name:	CST_COST_GROUP_ACCOUNTS
Object Type:	TABLE
Owner:	BOM
FND Design Data:	BOM.CST_COST_GROUP_ACCOUNTS
Subobject Name:
Status:	VALID

Stores all the pertinent accounts for a cost
group for an average costing organization.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CST_COST_GROUP_ACCOUNTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	COST_GROUP_ID ORGANIZATION_ID

Columns

Name	Datatype	Mandatory	Comments
COST_GROUP_ID	NUMBER	Yes	Cost group identifier
ORGANIZATION_ID	NUMBER	Yes	Organization identifier
LAST_UPDATE_DATE	DATE	Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	Yes	Standard Who column
CREATION_DATE	DATE	Yes	Standard Who column
CREATED_BY	NUMBER	Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER		Standard Who column
REQUEST_ID	NUMBER		Concurrent Who column
PROGRAM_APPLICATION_ID	NUMBER		Concurrent Who column
PROGRAM_ID	NUMBER		Concurrent Who column
PROGRAM_UPDATE_DATE	DATE		Concurrent Who column
MATERIAL_ACCOUNT	NUMBER		Inventory material account
MATERIAL_OVERHEAD_ACCOUNT	NUMBER		Inventory material overhead account
RESOURCE_ACCOUNT	NUMBER		Resource labor account
OVERHEAD_ACCOUNT	NUMBER		Inventory overhead account
OUTSIDE_PROCESSING_ACCOUNT	NUMBER		Outside processing account
AVERAGE_COST_VAR_ACCOUNT	NUMBER		Average cost variance account
ENCUMBRANCE_ACCOUNT	NUMBER		Encumbrance account
PAYBACK_MAT_VAR_ACCOUNT	NUMBER		Borrow payback variance account for material
PAYBACK_RES_VAR_ACCOUNT	NUMBER		Borrow payback variance account for resource
PAYBACK_OSP_VAR_ACCOUNT	NUMBER		Borrow payback variance account for outside processing
PAYBACK_MOH_VAR_ACCOUNT	NUMBER		Borrow payback variance account for material overhead
PAYBACK_OVH_VAR_ACCOUNT	NUMBER		Borrow payback variance account for overhead
EXPENSE_ACCOUNT	NUMBER		Expense Account
PURCHASE_PRICE_VAR_ACCOUNT	NUMBER		Purchase price variance is required for Standard costing organizations supporting project manufacturing

Query Text

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


SELECT COST_GROUP_ID
,      ORGANIZATION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      MATERIAL_ACCOUNT
,      MATERIAL_OVERHEAD_ACCOUNT
,      RESOURCE_ACCOUNT
,      OVERHEAD_ACCOUNT
,      OUTSIDE_PROCESSING_ACCOUNT
,      AVERAGE_COST_VAR_ACCOUNT
,      ENCUMBRANCE_ACCOUNT
,      PAYBACK_MAT_VAR_ACCOUNT
,      PAYBACK_RES_VAR_ACCOUNT
,      PAYBACK_OSP_VAR_ACCOUNT
,      PAYBACK_MOH_VAR_ACCOUNT
,      PAYBACK_OVH_VAR_ACCOUNT
,      EXPENSE_ACCOUNT
,      PURCHASE_PRICE_VAR_ACCOUNT
FROM BOM.CST_COST_GROUP_ACCOUNTS;

Dependencies

[top of page]

BOM.CST_COST_GROUP_ACCOUNTS does not reference any database object

BOM.CST_COST_GROUP_ACCOUNTS is referenced by following:

APPS: CST_COST_GROUP_ACCOUNTS