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_DB_WEEK_MAPS

Object Details

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

BSC_DB_WEEK_MAPS stores information about mapping between week 4 and week 54.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
YEAR	NUMBER	(5)	Yes	Year
MONTH	NUMBER	(3)	Yes	Month
WEEK	NUMBER	(3)	Yes	Week at Month to Date
WEEK52	NUMBER	(3)	Yes	Week at Year to Date
CALENDAR_ID	NUMBER			Calendar id

Query Text

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


SELECT YEAR
,      MONTH
,      WEEK
,      WEEK52
,      CALENDAR_ID
FROM BSC.BSC_DB_WEEK_MAPS;

Dependencies

[top of page]

BSC.BSC_DB_WEEK_MAPS does not reference any database object

BSC.BSC_DB_WEEK_MAPS is referenced by following:

APPS: BSC_DB_WEEK_MAPS