Skip to content

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

VIEW: APPS.FEM_CAL_PERIODS_VL

Object Details
Object Name: FEM_CAL_PERIODS_VL
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.


Calendar Period dimension members


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Uniquely identifies each row within mult-language views
OBJECT_VERSION_NUMBER NUMBER
Yes Internal column for concurrency purposes
READ_ONLY_FLAG VARCHAR2 (1) Yes Read only flag - a Y designates that the record cannot be edited by users
CAL_PERIOD_ID NUMBER
Yes Calendar Period member identifier
DIMENSION_GROUP_ID NUMBER (9) Yes Level (Dimension Group) internal identifier
CALENDAR_ID NUMBER (5) Yes Calendar member identifier
ENABLED_FLAG VARCHAR2 (1) Yes Enabled Flag - designates if the record is available for use (Y) or logically deleted (N)
PERSONAL_FLAG VARCHAR2 (1) Yes A Y designates that the record belongs to a personal dimension member that is only available to the user that created the member
CREATION_DATE DATE
Yes Creation Date for the record
CREATED_BY NUMBER (15) Yes Created By user
LAST_UPDATED_BY NUMBER (15) Yes Last Updated by user
LAST_UPDATE_DATE DATE
Yes Last update date for the record
LAST_UPDATE_LOGIN NUMBER (15)
Last update login for the record
CAL_PERIOD_NAME VARCHAR2 (150) Yes Calendar Period member translatable name
DESCRIPTION VARCHAR2 (255)
General Ledger Period Set member translatable name
Query Text

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


SELECT ROW_ID
,      OBJECT_VERSION_NUMBER
,      READ_ONLY_FLAG
,      CAL_PERIOD_ID
,      DIMENSION_GROUP_ID
,      CALENDAR_ID
,      ENABLED_FLAG
,      PERSONAL_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CAL_PERIOD_NAME
,      DESCRIPTION
FROM APPS.FEM_CAL_PERIODS_VL;

Dependencies

[top of page]

APPS.FEM_CAL_PERIODS_VL references the following:

SchemaAPPS
SynonymFEM_CAL_PERIODS_B
SynonymFEM_CAL_PERIODS_TL
APPS.FEM_CAL_PERIODS_VL is referenced by following:

SchemaAPPS
ViewFEM_CAL_PERIODS_BY_LEDGER_V
TriggerFEM_CAL_PERIODS_DL
TriggerFEM_CAL_PERIODS_IL
TriggerFEM_CAL_PERIODS_UL
Package BodyFEM_DATAX_LOADER_PKG - show dependent code
Package BodyFEM_DIM_UTILS_PVT - show dependent code
Package BodyFEM_DIS_UTL_PKG - show dependent code
PL/SQL PackageFEM_DS_WHERE_CLAUSE_GENERATOR - show dependent code
Package BodyFEM_DS_WHERE_CLAUSE_GENERATOR - show dependent code
Package BodyFEM_UD_PKG - show dependent code
Package BodyGCS_DATASUB_WF_PKG - show dependent code