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


VIEW: APPS.BSC_SYS_CALENDARS_VL

Object Details
Object Name: BSC_SYS_CALENDARS_VL
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBSC.BSC_SYS_CALENDARS_VL
ViewFND.BSC_SYS_CALENDARS_VL
Subobject Name:
Status: VALID

View Type

MultiLingual view (a language resolved view of the data.)


BSC_SYS_CALENDARS_VL is a view that joins the translated, language specific values from BSC_SYS_CALENDARS_TL with the non-displayed data from BSC_SYS_CALENDARS_B . BSC uses this view to display translated information in languages installed at your site.


[View Source]

Columns
Name Datatype Length Mandatory Comments
CALENDAR_ID NUMBER
Yes
EDW_FLAG NUMBER (1) Yes
EDW_CALENDAR_ID NUMBER

EDW_CALENDAR_TYPE_ID NUMBER

FISCAL_YEAR NUMBER (4) Yes
FISCAL_CHANGE NUMBER (1) Yes
RANGE_YR_MOD NUMBER (1) Yes
CURRENT_YEAR NUMBER (4)
START_MONTH NUMBER (2)
START_DAY NUMBER (3)
NAME VARCHAR2 (150)
HELP VARCHAR2 (240)
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
SHORT_NAME VARCHAR2 (30)
Query Text

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


SELECT CALENDAR_ID
,      EDW_FLAG
,      EDW_CALENDAR_ID
,      EDW_CALENDAR_TYPE_ID
,      FISCAL_YEAR
,      FISCAL_CHANGE
,      RANGE_YR_MOD
,      CURRENT_YEAR
,      START_MONTH
,      START_DAY
,      NAME
,      HELP
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SHORT_NAME
FROM APPS.BSC_SYS_CALENDARS_VL;

Dependencies

[top of page]

APPS.BSC_SYS_CALENDARS_VL references the following:

SchemaAPPS
SynonymBSC_SYS_CALENDARS_B
SynonymBSC_SYS_CALENDARS_TL
APPS.BSC_SYS_CALENDARS_VL is referenced by following:

SchemaAPPS
Package BodyBSC_BIS_LOCKS_PVT - show dependent code
Package BodyBSC_CALENDAR_PUB - show dependent code
Package BodyBSC_COPY_INDICATOR_PUB - show dependent code
Package BodyBSC_METADATA_DESC - show dependent code
Package BodyBSC_MO_DOC_PKG - show dependent code
Package BodyBSC_MO_HELPER_PKG - show dependent code
Package BodyBSC_PERIODICITIES_PUB - show dependent code
Package BodyBSC_PERIODS_UTILITY_PKG - show dependent code
Package BodyBSC_UPDATE_UTIL - show dependent code