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

TABLE: PA.PA_BIS_TOTALS_BY_PRD_ALL

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


PA_BIS_TOTALS_BY_PRD_ALL stores the data to be reported by the Oracle Business Intelligence System reports for Oracle Projects. The total cost and revenue is stored for a period.


Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PA_BIS_TOTALS_BY_PERIOD_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnAMOUNT_TYPE_CODE
Columns
Name Datatype Length Mandatory Comments
AMOUNT_TYPE_CODE VARCHAR2 (30)
The type of the amount, COST or REVENUE
PERIOD_NAME VARCHAR2 (30)
The period name for the data
ACCUMULATION_PERIOD_TYPE VARCHAR2 (30)
The type of period for accumulation
START_DATE DATE

The start date of the period
END_DATE DATE

The end date of the period
SORT_ORDER VARCHAR2 (60)
The order in which the data is to be sorted in
ACTUAL NUMBER

The actual amount column for cost or revenue
BUDGET NUMBER

The budget amount column Only current versions of approved cost and approved revenue budgets used
ORG_ID NUMBER (15)
Operating unit identifier for multi-organization installations
Query Text

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


SELECT AMOUNT_TYPE_CODE
,      PERIOD_NAME
,      ACCUMULATION_PERIOD_TYPE
,      START_DATE
,      END_DATE
,      SORT_ORDER
,      ACTUAL
,      BUDGET
,      ORG_ID
FROM PA.PA_BIS_TOTALS_BY_PRD_ALL;

Dependencies

[top of page]

PA.PA_BIS_TOTALS_BY_PRD_ALL does not reference any database object

PA.PA_BIS_TOTALS_BY_PRD_ALL is referenced by following:

SchemaPA
ViewPA_BIS_TOTALS_BY_PRD_ALL#