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

TABLE: FA.FA_PERIOD_MAPS

Object Details
Object Name: FA_PERIOD_MAPS
Object Type: TABLE
Owner: FA
FND Design Data: TableOFA.FA_PERIOD_MAPS
Subobject Name:
Status: VALID


FA_PERIOD_MAPS contains numbers that define the range of periods
in any quarter and any fiscal year. Oracle Assets uses this table
to map capital spending amounts for each period into
quarter-to-date and year-to-date amounts when you run the
Budget-to-Actual Report.
.
This is a static table, and you cannot change any rows.
.
.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
QUARTER NUMBER (2)
Identifies the quarter
QTR_FIRST_PERIOD NUMBER (2)
First period in the current quarter
QTR_LAST_PERIOD NUMBER (2)
Current open period in the quarter
YEAR_FIRST_PERIOD NUMBER (2)
First period in the fiscal year -- always 1
YEAR_LAST_PERIOD NUMBER (2)
Current open period in the fiscal year
CREATED_BY NUMBER (15)
Standard Who column
CREATION_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
Query Text

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


SELECT QUARTER
,      QTR_FIRST_PERIOD
,      QTR_LAST_PERIOD
,      YEAR_FIRST_PERIOD
,      YEAR_LAST_PERIOD
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM FA.FA_PERIOD_MAPS;

Dependencies

[top of page]

FA.FA_PERIOD_MAPS does not reference any database object

FA.FA_PERIOD_MAPS is referenced by following:

SchemaFA
ViewFA_PERIOD_MAPS#