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

TABLE: BIM.BIM_DATES

Object Details
Object Name: BIM_DATES
Object Type: TABLE
Owner: BIM
Subobject Name:
Status: VALID


This table is used to pre calculate the periods based on GL period definitions


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
CREATION_DATE DATE

Standard who column
CREATED_BY NUMBER

Standard who column
LAST_UPDATE_DATE DATE

Standard who column
LAST_UPDATED_BY NUMBER

Standard who column
LAST_UPDATE_LOGIN NUMBER

Standard who column
TRDATE DATE

Transaction Date
FISCAL_MONTH VARCHAR2 (10)
Fiscal Month
FISCAL_MONTH_END DATE

Fiscal Month End
FISCAL_MONTH_NUM NUMBER

Fiscal month number
FISCAL_MONTH_START DATE

Fiscal Month Start
FISCAL_PERIOD_START DATE

Fiscal Period Start
FISCAL_QTR VARCHAR2 (10)
Fiscal Quarter
FISCAL_QTR_END DATE

Fiscal Quarter End
FISCAL_QTR_NUM NUMBER

Fiscal Quarter Number
FISCAL_QTR_START DATE

Fiscal Period Quarter Start
FISCAL_ROLL_YEAR_START DATE

Fiscal Period Rolling Year Start
FISCAL_YEAR VARCHAR2 (10)
Fiscal Year
FISCAL_YEAR_END DATE

Fiscal Period Year End
FISCAL_YEAR_START DATE

Fiscal Period Year Start
MONTH_ORDER NUMBER

Month Order
PRE_FISCAL_MONTH_END DATE

Previos FIscal Period Month End
PRE_FISCAL_MONTH_START VARCHAR2 (240)
Previos FIscal Period Month Start
PRE_FISCAL_QTR_END DATE

Previos FIscal Period Quarter End
PRE_FISCAL_QTR_START DATE

Previos FIscal Period Quarter Start
PRE_FISCAL_ROLL_YEAR_END DATE

Previos FIscal Period Roll Year End
PRE_FISCAL_ROLL_YEAR_START DATE

Previos FIscal Period Roll Year Start
PRE_FISCAL_YEAR_END DATE

Pre Fiscal Year End
PRE_FISCAL_YEAR_START DATE

Pre Fiscal Year start
PERIOD_TYPE VARCHAR2 (10)
Period Type
SECURITY_GROUP_ID NUMBER

This is used in hosted environments
Query Text

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;

Dependencies

[top of page]

BIM.BIM_DATES does not reference any database object

BIM.BIM_DATES is referenced by following:

SchemaAPPS
SynonymBIM_DATES