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

VIEW: APPS.BEN_EXT_FLD_VL

Object Details
Object Name: BEN_EXT_FLD_VL
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row Id
EXT_FLD_ID NUMBER (15) Yes System generated primary key column.
DECD_FLAG VARCHAR2 (30) Yes Decode Flag
SHORT_NAME VARCHAR2 (30)
Short Name
NAME VARCHAR2 (600)
Field Name
FRMT_MASK_TYP_CD VARCHAR2 (30)
Format Mask Type Code
CSR_CD VARCHAR2 (30)
Cursor Code
LVL_CD VARCHAR2 (30)
Repeating Level
ALWD_IN_RCD_CD VARCHAR2 (30)
References Lookup BEN_EXT_ALWD_IN_RECD
BUSINESS_GROUP_ID NUMBER (15)
Foreign key to HR_ALL_ORGANIZATION_UNITS
LAST_UPDATE_DATE DATE

Standard Who Column
LAST_UPDATED_BY NUMBER (15)
Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
CREATED_BY NUMBER (15)
Standard Who Column
CREATION_DATE DATE

Standard Who Column
OBJECT_VERSION_NUMBER NUMBER (9)
Change Indicator Column
LEGISLATION_CODE VARCHAR2 (30)
Legislation Code
GROUP_LVL_CD VARCHAR2 (30)
Group Level Code
Query Text

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


SELECT ROW_ID
,      EXT_FLD_ID
,      DECD_FLAG
,      SHORT_NAME
,      NAME
,      FRMT_MASK_TYP_CD
,      CSR_CD
,      LVL_CD
,      ALWD_IN_RCD_CD
,      BUSINESS_GROUP_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      OBJECT_VERSION_NUMBER
,      LEGISLATION_CODE
,      GROUP_LVL_CD
FROM APPS.BEN_EXT_FLD_VL;

Dependencies

[top of page]

APPS.BEN_EXT_FLD_VL references the following:

SchemaAPPS
SynonymBEN_EXT_FLD
SynonymBEN_EXT_FLD_TL

APPS.BEN_EXT_FLD_VL is not referenced by any database object