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

TABLE: FEM.FEM_SECONDARY_OWNERS

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


Secondary relationship details


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FEM_SECONDARY_OWNERS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCAL_PERIOD_ID
ColumnDATASET_CODE
ColumnSOURCE_SYSTEM_CODE
ColumnID_NUMBER
ColumnCUSTOMER_ID
ColumnTABLE_ID
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
CUSTOMER_ID NUMBER
Yes Unique numeric identifier of the Customer
DATASET_CODE NUMBER
Yes Dataset
ID_NUMBER NUMBER
Yes Uniquely identifies an instrument.
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
TABLE_ID NUMBER
Yes Account Table Identifier
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
,      CUSTOMER_ID
,      DATASET_CODE
,      ID_NUMBER
,      LAST_UPDATED_BY_OBJECT_ID
,      LAST_UPDATED_BY_REQUEST_ID
,      LEDGER_ID
,      SOURCE_SYSTEM_CODE
,      TABLE_ID
FROM FEM.FEM_SECONDARY_OWNERS;

Dependencies

[top of page]

FEM.FEM_SECONDARY_OWNERS does not reference any database object

FEM.FEM_SECONDARY_OWNERS is referenced by following:

SchemaAPPS
SynonymFEM_SECONDARY_OWNERS