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: FEM.FEM_ORG_STATS

Object Details

Object Name:	FEM_ORG_STATS
Object Type:	TABLE
Owner:	FEM
Subobject Name:
Status:	VALID

Statistics by Company Cost Center
Organization

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FEM_ORG_STATS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	CAL_PERIOD_ID DATASET_CODE LEDGER_ID COMPANY_COST_CENTER_ORG_ID TASK_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CAL_PERIOD_ID	NUMBER		Yes	Calendar Period
COMPANY_COST_CENTER_ORG_ID	NUMBER		Yes	Company Cost Center Organization
CREATED_BY_OBJECT_ID	NUMBER	(9)	Yes	Created by Object
CREATED_BY_REQUEST_ID	NUMBER		Yes	Created by Request
DATASET_CODE	NUMBER		Yes	Dataset Code
LAST_UPDATED_BY_OBJECT_ID	NUMBER	(9)	Yes	Last Updated by Object
LAST_UPDATED_BY_REQUEST_ID	NUMBER		Yes	Last Updated by Request
LEDGER_ID	NUMBER		Yes	Ledger
TASK_ID	NUMBER		Yes	Task
VALUE	NUMBER		Yes	Value
SOURCE_SYSTEM_CODE	NUMBER		Yes	Source System
VALUE_UOM_CODE	VARCHAR2	(30)	Yes	Value Unit of Measure

Query Text

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


SELECT CAL_PERIOD_ID
,      COMPANY_COST_CENTER_ORG_ID
,      CREATED_BY_OBJECT_ID
,      CREATED_BY_REQUEST_ID
,      DATASET_CODE
,      LAST_UPDATED_BY_OBJECT_ID
,      LAST_UPDATED_BY_REQUEST_ID
,      LEDGER_ID
,      TASK_ID
,      VALUE
,      SOURCE_SYSTEM_CODE
,      VALUE_UOM_CODE
FROM FEM.FEM_ORG_STATS;

Dependencies

[top of page]

FEM.FEM_ORG_STATS does not reference any database object

FEM.FEM_ORG_STATS is referenced by following:

APPS: FEM_ORG_STATS