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_EAM_BALANCE_BY_ACCOUNTS

Object Details

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

This table stores estimated costs based on WIP Entity and the GL accounts that the charges are expected to hit.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CST_EAM_BALANCE_BY_ACCOUNTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	WIP_ENTITY_ID ORGANIZATION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PERIOD_SET_NAME	VARCHAR2	(15)	Yes	Period Set Name
PERIOD_NAME	VARCHAR2	(15)	Yes	Period Name
ACCT_PERIOD_ID	NUMBER			Account Period Id
WIP_ENTITY_ID	NUMBER		Yes	Wip Entity Id
ORGANIZATION_ID	NUMBER		Yes	Organization id
OPERATIONS_DEPT_ID	NUMBER			Operations Department Id
OPERATIONS_SEQ_NUM	NUMBER			Operations Department Id
MAINT_COST_CATEGORY	NUMBER		Yes	Maintenance cost category
OWNING_DEPT_ID	NUMBER		Yes	Owning department id
PERIOD_START_DATE	DATE		Yes	Period start date
ACCOUNT_ID	NUMBER		Yes	Wip Accounting Class Account Id
ACCT_VALUE	NUMBER		Yes	Amount charged to the account
TXN_TYPE	NUMBER		Yes	Material, Labor or Equipment
WIP_ACCT_CLASS_CODE	VARCHAR2	(10)	Yes	WIP Accounting Class Code
MFG_COST_ELEMENT_ID	NUMBER		Yes	Manufacturing Cost Element Id
CREATED_BY	NUMBER			Standard Who column
CREATION_DATE	DATE			Standard Who column
LAST_UPDATED_BY	NUMBER			Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
LAST_UPDATE_DATE	DATE			Standard Who column

Query Text

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


SELECT PERIOD_SET_NAME
,      PERIOD_NAME
,      ACCT_PERIOD_ID
,      WIP_ENTITY_ID
,      ORGANIZATION_ID
,      OPERATIONS_DEPT_ID
,      OPERATIONS_SEQ_NUM
,      MAINT_COST_CATEGORY
,      OWNING_DEPT_ID
,      PERIOD_START_DATE
,      ACCOUNT_ID
,      ACCT_VALUE
,      TXN_TYPE
,      WIP_ACCT_CLASS_CODE
,      MFG_COST_ELEMENT_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
FROM BOM.CST_EAM_BALANCE_BY_ACCOUNTS;

Dependencies

[top of page]

BOM.CST_EAM_BALANCE_BY_ACCOUNTS does not reference any database object

BOM.CST_EAM_BALANCE_BY_ACCOUNTS is referenced by following:

BOM: CST_EAM_BALANCE_BY_ACCOUNTS#