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]

VIEW: APPS.FEM_DATA_LOCATIONS

Object Details

Object Name:	FEM_DATA_LOCATIONS
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

This view stores information about where data is stored in the system. Data is identified by a dimension combination and the table name storing the combination. It is possible for the same combination to be stored in multiple tables.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
LEDGER_ID	NUMBER		Yes	Ledger member identifier
CAL_PERIOD_ID	NUMBER		Yes	Calendar Period member identifier
DATASET_CODE	NUMBER		Yes	Dataset member identifier
SOURCE_SYSTEM_CODE	NUMBER		Yes	Source System member identifier
TABLE_NAME	VARCHAR2	(30)	Yes	Name of the fact table where the dimension data resides
BALANCE_TYPE_CODE	VARCHAR2	(30)		Designates the Balance Type of the Dataset
AVG_BALANCES_FLAG	VARCHAR2	(1)		Determines if Average Balances were loaded: (Y) if Average Balances were loaded, (N) if Average Balances were not loaded, null if Average Balances are not applicable.
LOAD_STATUS	VARCHAR2	(30)		Status of the process or load that created the dimension data in the fact table
LAST_UPDATE_DATE	DATE			Identifies the data on which the data was last updated

Query Text

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


SELECT LEDGER_ID
,      CAL_PERIOD_ID
,      DATASET_CODE
,      SOURCE_SYSTEM_CODE
,      TABLE_NAME
,      BALANCE_TYPE_CODE
,      AVG_BALANCES_FLAG
,      LOAD_STATUS
,      LAST_UPDATE_DATE
FROM APPS.FEM_DATA_LOCATIONS;

Dependencies

[top of page]

APPS.FEM_DATA_LOCATIONS references the following:

APPS: FEM_DL_DIMENSIONS

APPS.FEM_DATA_LOCATIONS is referenced by following:

APPS: FEM_INTG_DIM_RULE_ENG_PKG - show dependent code; GCS_DATASUB_WF_PKG - show dependent code; GCS_DATA_PREP_PKG - show dependent code; GCS_DP_DYNAMIC_PKG - show dependent code; GCS_DRILLDOWN_UTIL_PKG - show dependent code; ZPB_BUSAREA_MAINT - show dependent code; ZPB_BUSAREA_VAL - show dependent code; ZPB_DRILL_INFO - show dependent code