[Home] [Help]
[Dependency Information]
| Object Name: | BSC_SYS_CALENDARS_VL |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | BSC.BSC_SYS_CALENDARS_VL
FND.BSC_SYS_CALENDARS_VL
|
| Subobject Name: | |
| Status: | VALID |
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.
| 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) |
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;
APPS
BSC_SYS_CALENDARS_B
BSC_SYS_CALENDARS_TL
APPS
BSC_BIS_LOCKS_PVT
- show dependent code
BSC_CALENDAR_PUB
- show dependent code
BSC_COPY_INDICATOR_PUB
- show dependent code
BSC_METADATA_DESC
- show dependent code
BSC_MO_DOC_PKG
- show dependent code
BSC_MO_HELPER_PKG
- show dependent code
BSC_PERIODICITIES_PUB
- show dependent code
BSC_PERIODS_UTILITY_PKG
- show dependent code
BSC_UPDATE_UTIL
- show dependent code
|
|
|
|