eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: BSC.BSC_SYS_CALENDARS_B

Object Details

Object Name:	BSC_SYS_CALENDARS_B
Object Type:	TABLE
Owner:	BSC
FND Design Data:	BSC.BSC_SYS_CALENDARS_B
Subobject Name:
Status:	VALID

BSC_SYS_CALENDAR S_B stores information about calendars. Each row includes calendar id, the fiscal year,Edw calendar id, Edw calendar type id and etc..

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
BSC_SYS_CALENDARS_B_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CALENDAR_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CALENDAR_ID	NUMBER		Yes	Calendar identifier
EDW_FLAG	NUMBER	(1)	Yes	EDW identifier
EDW_CALENDAR_ID	NUMBER			EDW Calendar identifier
EDW_CALENDAR_TYPE_ID	NUMBER			EDW Calendar type identifier
FISCAL_YEAR	NUMBER	(4)	Yes	Fiscal year of the current calendar
FISCAL_CHANGE	NUMBER	(1)	Yes	Flag to indicates that fiscal year had changed
RANGE_YR_MOD	NUMBER	(1)	Yes	Flag to indicates that range of years had changed
CURRENT_YEAR	NUMBER	(4)		Current calendar year
START_MONTH	NUMBER	(2)		Start Calendar Month
START_DAY	NUMBER	(3)		Start Calendar day
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
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
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SHORT_NAME
FROM BSC.BSC_SYS_CALENDARS_B;

Dependencies

[top of page]

BSC.BSC_SYS_CALENDARS_B does not reference any database object

BSC.BSC_SYS_CALENDARS_B is referenced by following:

APPS: BSC_SYS_CALENDARS_B