[Home] [Help] [Dependency Information]
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
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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;
BOM.CST_PAC_EAM_BALANCE_BY_ACCTS does not reference any database object
BOM.CST_PAC_EAM_BALANCE_BY_ACCTS is referenced by following:
|
|
|