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

TABLE: FEM.FEM_REGION_INFO

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


Region counting information


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FEM_REGION_INFO_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCAL_PERIOD_ID
ColumnDATASET_CODE
ColumnSOURCE_SYSTEM_CODE
ColumnDIMENSION_GROUP_ID
ColumnLEDGER_ID
ColumnREGION_CODE
Columns
Name Datatype Length Mandatory Comments
CAL_PERIOD_ID NUMBER
Yes Calendar Period
CREATED_BY_OBJECT_ID NUMBER (9) Yes Created By Object
CREATED_BY_REQUEST_ID NUMBER
Yes Created By Request
DATASET_CODE NUMBER
Yes Dataset
DIMENSION_GROUP_ID NUMBER
Yes Dimension group
LAST_UPDATED_BY_OBJECT_ID NUMBER (9) Yes Object that last updated the row. References FEM_PL_OBJECT_EXECUTIONS.OBJECT_ID
LAST_UPDATED_BY_REQUEST_ID NUMBER
Yes Request that last updated the row. References FEM_PL_OBJECT_EXECUTIONS.REQUEST_ID
LEDGER_ID NUMBER
Yes Ledger
SOURCE_SYSTEM_CODE NUMBER
Yes Source System
NUMBER_OF_CUSTOMERS NUMBER

Number of customers in region
REGION_CODE NUMBER

Region Code
REGION_PCT_TOTAL_CUST NUMBER

Percentage of customers in region to total number of customers in valuation set
Query Text

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


SELECT CAL_PERIOD_ID
,      CREATED_BY_OBJECT_ID
,      CREATED_BY_REQUEST_ID
,      DATASET_CODE
,      DIMENSION_GROUP_ID
,      LAST_UPDATED_BY_OBJECT_ID
,      LAST_UPDATED_BY_REQUEST_ID
,      LEDGER_ID
,      SOURCE_SYSTEM_CODE
,      NUMBER_OF_CUSTOMERS
,      REGION_CODE
,      REGION_PCT_TOTAL_CUST
FROM FEM.FEM_REGION_INFO;

Dependencies

[top of page]

FEM.FEM_REGION_INFO does not reference any database object

FEM.FEM_REGION_INFO is referenced by following:

SchemaAPPS
SynonymFEM_REGION_INFO