DBA Data[Home] [Help] [Dependency Information]

VIEW: BOM.CST_PAC_EAM_BALANCE_BY_ACCTS#

Object Details
Object Name: CST_PAC_EAM_BALANCE_BY_ACCTS#
Object Type: VIEW
Owner: BOM
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
LEGAL_ENTITY_ID NUMBER
Yes
COST_GROUP_ID NUMBER
Yes
COST_TYPE_ID NUMBER
Yes
PERIOD_SET_NAME VARCHAR2 (15) Yes
PERIOD_NAME VARCHAR2 (15) Yes
ACCT_PERIOD_ID NUMBER

WIP_ENTITY_ID NUMBER
Yes
ORGANIZATION_ID NUMBER
Yes
OPERATIONS_DEPT_ID NUMBER

OPERATIONS_SEQ_NUM NUMBER

MAINT_COST_CATEGORY NUMBER
Yes
OWNING_DEPT_ID NUMBER
Yes
PERIOD_START_DATE DATE
Yes
ACCOUNT_ID NUMBER
Yes
ACCT_VALUE NUMBER
Yes
TXN_TYPE NUMBER
Yes
WIP_ACCT_CLASS_CODE VARCHAR2 (10) Yes
MFG_COST_ELEMENT_ID NUMBER
Yes
CREATED_BY NUMBER

CREATION_DATE DATE

LAST_UPDATED_BY NUMBER

LAST_UPDATE_LOGIN NUMBER

LAST_UPDATE_DATE DATE

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# references the following:

SchemaBOM
TableCST_PAC_EAM_BALANCE_BY_ACCTS
BOM.CST_PAC_EAM_BALANCE_BY_ACCTS# is referenced by following:

SchemaAPPS
SynonymCST_PAC_EAM_BALANCE_BY_ACCTS