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

VIEW: APPS.FEM_VALUE_SETS_VL

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


Value Set dimension members


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Uniquely identifies each row within mult-language views
DEFAULT_LOAD_MEMBER_ID NUMBER

This is the Not Applicable value for each value set, to be used in fact table loads into NOT NULL dimension columns when that dimension is not applicable or is not available from the source being loaded.
VALUE_SET_ID NUMBER
Yes Value Set member identifier
DEFAULT_MEMBER_ID NUMBER

Designates the default member from the value set for data insert operations when a specific member is otherwise not available.
CREATION_DATE DATE
Yes Creation Date for the record
CREATED_BY NUMBER
Yes Created By user
LAST_UPDATED_BY NUMBER
Yes Last Updated by user
OBJECT_VERSION_NUMBER NUMBER
Yes Internal column for concurrency purposes
DEFAULT_HIERARCHY_OBJ_ID NUMBER (9)
Default hierarchy internal identifier
READ_ONLY_FLAG VARCHAR2 (1) Yes Read only flag - a Y designates that the record cannot be edited by users
VALUE_SET_DISPLAY_CODE VARCHAR2 (150) Yes Value Set member alphanumeric user identifier
DIMENSION_ID NUMBER
Yes Dimension internal identifier
LAST_UPDATE_DATE DATE
Yes Last update date for the record
LAST_UPDATE_LOGIN NUMBER

Last update login for the record
VALUE_SET_NAME VARCHAR2 (150) Yes Value Set 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
,      DEFAULT_LOAD_MEMBER_ID
,      VALUE_SET_ID
,      DEFAULT_MEMBER_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      OBJECT_VERSION_NUMBER
,      DEFAULT_HIERARCHY_OBJ_ID
,      READ_ONLY_FLAG
,      VALUE_SET_DISPLAY_CODE
,      DIMENSION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      VALUE_SET_NAME
,      DESCRIPTION
FROM APPS.FEM_VALUE_SETS_VL;

Dependencies

[top of page]

APPS.FEM_VALUE_SETS_VL references the following:

SchemaAPPS
SynonymFEM_VALUE_SETS_B
SynonymFEM_VALUE_SETS_TL
APPS.FEM_VALUE_SETS_VL is referenced by following:

SchemaAPPS
Package BodyFEM_CHECK_BR_DIS_MBRS_PKG - show dependent code
Package BodyFEM_DIMENSION_MIGRATION_PKG - show dependent code
TriggerFEM_VALUE_SETS_DL
TriggerFEM_VALUE_SETS_IL
TriggerFEM_VALUE_SETS_UL
Package BodyFEM_WEBADI_HIER_UTILS_PVT - show dependent code
Package BodyFEM_WEBADI_MEMBER_UTILS_PVT - show dependent code
Package BodyFEM_XGL_POST_ENGINE_PKG - show dependent code
Package BodyGCS_RAISE_EVENT_PKG - show dependent code
Package BodyZPB_BUSAREA_MAINT - show dependent code