[Home] [Help] [Dependency Information]

VIEW: APPS.BSC_SYS_PERIODICITIES_VL

Object Details

Object Name:	BSC_SYS_PERIODICITIES_VL
Object Type:	VIEW
Owner:	APPS
FND Design Data:	BSC.BSC_SYS_PERIODICITIES_VL FND.BSC_SYS_PERIODICITIES_VL
Subobject Name:
Status:	VALID

View Type

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

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

[View Source]

Columns

Query Text

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

SELECT PERIODICITY_ID
,      NUM_OF_PERIODS
,      SOURCE
,      NUM_OF_SUBPERIODS
,      PERIOD_COL_NAME
,      SUBPERIOD_COL_NAME
,      YEARLY_FLAG
,      EDW_FLAG
,      CALENDAR_ID
,      EDW_PERIODICITY_ID
,      CUSTOM_CODE
,      DB_COLUMN_NAME
,      PERIODICITY_TYPE
,      NAME
,      PERIOD_TYPE_ID
,      RECORD_TYPE_ID
,      XTD_PATTERN
,      SHORT_NAME
FROM APPS.BSC_SYS_PERIODICITIES_VL;

Dependencies

[top of page]

APPS

BSC_LOOKUPS

BSC_SYS_CALENDARS_B

BSC_SYS_PERIODICITIES

BSC_SYS_PERIODICITIES_TL

APPS

BSC_BIS_LOCKS_PVT - show dependent code

BSC_CALENDAR_PUB - show dependent code

BSC_CALENDAR_PVT - show dependent code

BSC_COPY_INDICATOR_PUB - show dependent code

BSC_DBGEN_BSC_READER - show dependent code

BSC_METADATA_DESC - show dependent code

BSC_MO_DOC_PKG - show dependent code

BSC_MO_HELPER_PKG - show dependent code

BSC_MO_UI_PKG - show dependent code

BSC_PERIODICITIES_PUB - show dependent code

BSC_PERIODICITIES_PVT - show dependent code

BSC_PERIODS_UTILITY_PKG - show dependent code

BSC_PMF_UI_WRAPPER - show dependent code

BSC_UPDATE - show dependent code