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

TABLE: FEM.FEM_ORG_CRNCY_STATS

Object Details
Object Name: FEM_ORG_CRNCY_STATS
Object Type: TABLE
Owner: FEM
Subobject Name:
Status: VALID


Statistics by Company Cost Center
Organization and Currency


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FEM_ORG_CRNCY_STATS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCAL_PERIOD_ID
ColumnDATASET_CODE
ColumnLEDGER_ID
ColumnCOMPANY_COST_CENTER_ORG_ID
ColumnCURRENCY_CODE
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
CURRENCY_CODE VARCHAR2 (15) Yes Currency Code
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
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
,      CURRENCY_CODE
,      DATASET_CODE
,      LAST_UPDATED_BY_OBJECT_ID
,      LAST_UPDATED_BY_REQUEST_ID
,      LEDGER_ID
,      VALUE
,      SOURCE_SYSTEM_CODE
,      VALUE_UOM_CODE
FROM FEM.FEM_ORG_CRNCY_STATS;

Dependencies

[top of page]

FEM.FEM_ORG_CRNCY_STATS does not reference any database object

FEM.FEM_ORG_CRNCY_STATS is referenced by following:

SchemaAPPS
SynonymFEM_ORG_CRNCY_STATS