[Home] [Help] [Dependency Information]
Object Name: | PA_BIS_TO_DATE_DRILLS_ALL |
---|---|
Object Type: | TABLE |
Owner: | PA |
FND Design Data: | PA.PA_BIS_TO_DATE_DRILLS_ALL |
Subobject Name: | |
Status: | VALID |
PA_BIS_TOTALS_TO_DATE_DRILLS_ALL stores the data to be reportd by the Oracle Business Intelligence System reports for Oracle Projects. The period and year to date data for cost and revenue is stored for a period.
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PA_BIS_TO_DATE_DRILLDOWNS_N1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY |
DRILLDOWN_TYPE
AMOUNT_TYPE_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DRILLDOWN_TYPE | VARCHAR2 | (30) | The type of drilldown associated with the data | |
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_KEY1 | VARCHAR2 | (30) | The key used for drilldown to the next report | |
DRILLDOWN_KEY2 | VARCHAR2 | (30) | The key used for drilldown to the next report | |
DRILLDOWN_KEY3 | VARCHAR2 | (30) | The key used for drilldown to the next report | |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT DRILLDOWN_TYPE
, AMOUNT_TYPE_CODE
, SORT_ORDER
, DRILLDOWN_KEY1
, DRILLDOWN_KEY2
, DRILLDOWN_KEY3
, ACTUAL_PTD
, BUDGET_PTD
, ACTUAL_YTD
, BUDGET_YTD
, ORG_ID
FROM PA.PA_BIS_TO_DATE_DRILLS_ALL;
PA.PA_BIS_TO_DATE_DRILLS_ALL does not reference any database object
PA.PA_BIS_TO_DATE_DRILLS_ALL is referenced by following:
|
|
|