[Home] [Help] [Dependency Information]
Object Name: | BIM_DATES# |
---|---|
Object Type: | VIEW |
Owner: | BIM |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CREATION_DATE | DATE | |||
CREATED_BY | NUMBER | |||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | |||
LAST_UPDATE_LOGIN | NUMBER | |||
TRDATE | DATE | |||
FISCAL_MONTH | VARCHAR2 | (10) | ||
FISCAL_MONTH_END | DATE | |||
FISCAL_MONTH_NUM | NUMBER | |||
FISCAL_MONTH_START | DATE | |||
FISCAL_PERIOD_START | DATE | |||
FISCAL_QTR | VARCHAR2 | (10) | ||
FISCAL_QTR_END | DATE | |||
FISCAL_QTR_NUM | NUMBER | |||
FISCAL_QTR_START | DATE | |||
FISCAL_ROLL_YEAR_START | DATE | |||
FISCAL_YEAR | VARCHAR2 | (10) | ||
FISCAL_YEAR_END | DATE | |||
FISCAL_YEAR_START | DATE | |||
MONTH_ORDER | NUMBER | |||
PRE_FISCAL_MONTH_END | DATE | |||
PRE_FISCAL_MONTH_START | VARCHAR2 | (240) | ||
PRE_FISCAL_QTR_END | DATE | |||
PRE_FISCAL_QTR_START | DATE | |||
PRE_FISCAL_ROLL_YEAR_END | DATE | |||
PRE_FISCAL_ROLL_YEAR_START | DATE | |||
PRE_FISCAL_YEAR_END | DATE | |||
PRE_FISCAL_YEAR_START | DATE | |||
PERIOD_TYPE | VARCHAR2 | (10) | ||
SECURITY_GROUP_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, TRDATE
, FISCAL_MONTH
, FISCAL_MONTH_END
, FISCAL_MONTH_NUM
, FISCAL_MONTH_START
, FISCAL_PERIOD_START
, FISCAL_QTR
, FISCAL_QTR_END
, FISCAL_QTR_NUM
, FISCAL_QTR_START
, FISCAL_ROLL_YEAR_START
, FISCAL_YEAR
, FISCAL_YEAR_END
, FISCAL_YEAR_START
, MONTH_ORDER
, PRE_FISCAL_MONTH_END
, PRE_FISCAL_MONTH_START
, PRE_FISCAL_QTR_END
, PRE_FISCAL_QTR_START
, PRE_FISCAL_ROLL_YEAR_END
, PRE_FISCAL_ROLL_YEAR_START
, PRE_FISCAL_YEAR_END
, PRE_FISCAL_YEAR_START
, PERIOD_TYPE
, SECURITY_GROUP_ID
FROM BIM.BIM_DATES#;
|
|
|