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

TABLE: PA.PA_BIS_TOTALS_TO_DATE_ALL

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


PA_BIS_TOTALS_TO_DATE_ALL stores the data to be reported by the Oracle Business Intelligence System reports for Oracle Projects. The period and year to date data for cost and revenue is stored.


Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PA_BIS_TOTALS_TO_DATE_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
SORT_ORDER VARCHAR2 (60)
The order in which the data is to be sorted in
DRILLDOWN_INDICATOR VARCHAR2 (1)
The flag to indicate if there is nay drill available for this record Values are Y,N
ACTUAL_PTD NUMBER

The period to date values for the actual amount
BUDGET_PTD NUMBER

The period to date values for the budget amount
ACTUAL_YTD NUMBER

The year to date values for the actual amount
BUDGET_YTD NUMBER

The year to date values for the budget amount
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
,      SORT_ORDER
,      DRILLDOWN_INDICATOR
,      ACTUAL_PTD
,      BUDGET_PTD
,      ACTUAL_YTD
,      BUDGET_YTD
,      ORG_ID
FROM PA.PA_BIS_TOTALS_TO_DATE_ALL;

Dependencies

[top of page]

PA.PA_BIS_TOTALS_TO_DATE_ALL does not reference any database object

PA.PA_BIS_TOTALS_TO_DATE_ALL is referenced by following:

SchemaPA
ViewPA_BIS_TOTALS_TO_DATE_ALL#