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

VIEW: BIM.BIM_INTL_DATES#

Object Details
Object Name: BIM_INTL_DATES#
Object Type: VIEW
Owner: BIM
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
TRDATE DATE
Yes
YEAR VARCHAR2 (30)
QTR VARCHAR2 (30)
MONTH VARCHAR2 (30)
QTR_NUM NUMBER

MONTH_NUM NUMBER

SECURITY_GROUP_ID NUMBER

FISCAL_MONTH VARCHAR2 (30)
MONTH_FLAG VARCHAR2 (1)
FISCAL_QTR VARCHAR2 (30)
QTR_FLAG VARCHAR2 (1)
FISCAL_YEAR VARCHAR2 (30)
YEAR_FLAG VARCHAR2 (1)
FISCAL_MONTH_START DATE

FISCAL_MONTH_END DATE

FISCAL_QTR_START DATE

FISCAL_QTR_END DATE

FISCAL_YEAR_START DATE

FISCAL_YEAR_END DATE

FISCAL_ROLL_YEAR_START DATE

PRE_FISCAL_MONTH_START DATE

PRE_FISCAL_MONTH_END DATE

PRE_FISCAL_QTR_START DATE

PRE_FISCAL_QTR_END DATE

PRE_FISCAL_YEAR_START DATE

PRE_FISCAL_YEAR_END DATE

PRE_FISCAL_ROLL_YEAR_START DATE

PRE_FISCAL_ROLL_YEAR_END DATE

Query Text

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


SELECT TRDATE
,      YEAR
,      QTR
,      MONTH
,      QTR_NUM
,      MONTH_NUM
,      SECURITY_GROUP_ID
,      FISCAL_MONTH
,      MONTH_FLAG
,      FISCAL_QTR
,      QTR_FLAG
,      FISCAL_YEAR
,      YEAR_FLAG
,      FISCAL_MONTH_START
,      FISCAL_MONTH_END
,      FISCAL_QTR_START
,      FISCAL_QTR_END
,      FISCAL_YEAR_START
,      FISCAL_YEAR_END
,      FISCAL_ROLL_YEAR_START
,      PRE_FISCAL_MONTH_START
,      PRE_FISCAL_MONTH_END
,      PRE_FISCAL_QTR_START
,      PRE_FISCAL_QTR_END
,      PRE_FISCAL_YEAR_START
,      PRE_FISCAL_YEAR_END
,      PRE_FISCAL_ROLL_YEAR_START
,      PRE_FISCAL_ROLL_YEAR_END
FROM BIM.BIM_INTL_DATES#;

Dependencies

[top of page]

BIM.BIM_INTL_DATES# references the following:

SchemaBIM
TableBIM_INTL_DATES
BIM.BIM_INTL_DATES# is referenced by following:

SchemaAPPS
SynonymBIM_INTL_DATES