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

TABLE: PA.PA_ALL_FINANCIAL_YRS_IT

Object Details
Object Name: PA_ALL_FINANCIAL_YRS_IT
Object Type: TABLE
Owner: PA
FND Design Data: TablePA.PA_ALL_FINANCIAL_YRS_IT
Subobject Name:
Status: VALID


PA_ALL_FINANCIAL_YRS_IT stores information about top level for the
standard hierarchy on the time dimension for Oracle Project Analysis
Collection Pack.


Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PA_ALL_FINANCIAL_YRS_IT_U1 NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnALL_FINANCIAL_YEARS
Columns
Name Datatype Length Mandatory Comments
ALL_FINANCIAL_YEARS VARCHAR2 (30) Yes This column stores the top level dimension value for Standard Hierarchy on Time dimension
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who Column
CREATION_DATE DATE
Yes Standard Who Column
CREATED_BY NUMBER (15) Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
REQUEST_ID NUMBER (15)
Standard Who Column
PROGRAM_APPLICATION_ID NUMBER (15)
Standard Who Column
PROGRAM_ID NUMBER (15)
Standard Who Column
PROGRAM_UPDATE_DATE DATE

Standard Who Column
STATUS_CODE VARCHAR2 (1)
The flag that indicates whether this row has any updates or not.
Query Text

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


SELECT ALL_FINANCIAL_YEARS
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      STATUS_CODE
FROM PA.PA_ALL_FINANCIAL_YRS_IT;

Dependencies

[top of page]

PA.PA_ALL_FINANCIAL_YRS_IT does not reference any database object

PA.PA_ALL_FINANCIAL_YRS_IT is referenced by following:

SchemaAPPS
SynonymPA_ALL_FINANCIAL_YRS_IT