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_PAC_EAM_BALANCE_BY_ACCTS

Object Details

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

Estimated Cost Information by WAC Accounts for PAC

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
LEGAL_ENTITY_ID	NUMBER		Yes	Legal Entity
COST_GROUP_ID	NUMBER		Yes	Cost Group
COST_TYPE_ID	NUMBER		Yes	Cost Type
PERIOD_SET_NAME	VARCHAR2	(15)	Yes	Period Set Name
PERIOD_NAME	VARCHAR2	(15)	Yes	Period Name
ACCT_PERIOD_ID	NUMBER			Account period ID. Can be 0 if a future period.
WIP_ENTITY_ID	NUMBER		Yes	Job id
ORGANIZATION_ID	NUMBER		Yes	Organization id
OPERATIONS_DEPT_ID	NUMBER			Operations deparment id
OPERATIONS_SEQ_NUM	NUMBER			Operations seq num
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 acct
TXN_TYPE	NUMBER		Yes	Material, Labor or Equipment
WIP_ACCT_CLASS_CODE	VARCHAR2	(10)	Yes	Accounting Class Code
MFG_COST_ELEMENT_ID	NUMBER		Yes	Manufacturing Cost Element Id
CREATED_BY	NUMBER			Who Column
CREATION_DATE	DATE			Who Column
LAST_UPDATED_BY	NUMBER			Who Column
LAST_UPDATE_LOGIN	NUMBER			Who Column
LAST_UPDATE_DATE	DATE			Who Column

Query Text

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


SELECT LEGAL_ENTITY_ID
,      COST_GROUP_ID
,      COST_TYPE_ID
,      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_PAC_EAM_BALANCE_BY_ACCTS;

Dependencies

[top of page]

BOM.CST_PAC_EAM_BALANCE_BY_ACCTS does not reference any database object

BOM.CST_PAC_EAM_BALANCE_BY_ACCTS is referenced by following:

APPS: CST_PAC_EAM_BALANCE_BY_ACCTS