[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT YEAR
, MONTH
, WEEK
, WEEK52
, CALENDAR_ID
FROM BSC.BSC_DB_WEEK_MAPS;
BSC.BSC_DB_WEEK_MAPS does not reference any database object
BSC.BSC_DB_WEEK_MAPS is referenced by following:
|
|
|