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

VIEW: APPS.FEM_BUDG_STATUS_CODES_VL

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


Budget Status Code dimension members


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Uniquely identifies each row within mult-language views
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
BUDGET_STATUS_CODE VARCHAR2 (30) Yes Budget Status Code member identifier
ENABLED_FLAG VARCHAR2 (1) Yes Enabled Flag - designates if the record is available for use (Y) or logically deleted (N)
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
LAST_UPDATE_DATE DATE
Yes Last update date for the record
LAST_UPDATE_LOGIN NUMBER

Last update login for the record
READ_ONLY_FLAG VARCHAR2 (1) Yes Read only flag - a Y designates that the record cannot be edited by users
BUDGET_STATUS_NAME VARCHAR2 (150) Yes Budget Status Code 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
,      PERSONAL_FLAG
,      BUDGET_STATUS_CODE
,      ENABLED_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      READ_ONLY_FLAG
,      BUDGET_STATUS_NAME
,      DESCRIPTION
FROM APPS.FEM_BUDG_STATUS_CODES_VL;

Dependencies

[top of page]

APPS.FEM_BUDG_STATUS_CODES_VL references the following:

SchemaAPPS
SynonymFEM_BUDG_STATUS_CODES_B
SynonymFEM_BUDG_STATUS_CODES_TL
APPS.FEM_BUDG_STATUS_CODES_VL is referenced by following:

SchemaAPPS
TriggerFEM_BUDG_STATUS_CODES_DL
TriggerFEM_BUDG_STATUS_CODES_IL
TriggerFEM_BUDG_STATUS_CODES_UL