[Home] [Help] [Dependency Information]
Object Name: | PA_BIS_PRJ_TO_DATE_DRILLS_ALL |
---|---|
Object Type: | TABLE |
Owner: | PA |
FND Design Data: | PA.PA_BIS_PRJ_TO_DATE_DRILLS_ALL |
Subobject Name: | |
Status: | VALID |
PA_BIS_PRJ_TO_DATE_DRILLS_ALL stores the data to be reported by the Oracle Business Intelligence Systems reports for Oracle Projects. The period and year to date data for a project is categorized by various columns and shown.
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PA_BIS_PRJ_TO_DATE_DRLDNS_N1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY |
DRILLDOWN_TYPE
AMOUNT_TYPE_CODE DRILLDOWN_KEY1 DRILLDOWN_KEY2 |
PA_BIS_PRJ_TO_DATE_DRLDNS_N2 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | PROJECT_ID |
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 | |
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 | |
PROJECT_ID | NUMBER | The identifier of the project | ||
PROJECT_NUMBER | VARCHAR2 | (25) | The project number of the project | |
PROJECT_NAME | VARCHAR2 | (30) | The name of the project | |
SORT_ORDER | VARCHAR2 | (60) | The order in which the data is to be sorted in | |
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
, DRILLDOWN_KEY1
, DRILLDOWN_KEY2
, DRILLDOWN_KEY3
, PROJECT_ID
, PROJECT_NUMBER
, PROJECT_NAME
, SORT_ORDER
, ACTUAL_PTD
, BUDGET_PTD
, ACTUAL_YTD
, BUDGET_YTD
, ORG_ID
FROM PA.PA_BIS_PRJ_TO_DATE_DRILLS_ALL;
PA.PA_BIS_PRJ_TO_DATE_DRILLS_ALL does not reference any database object
PA.PA_BIS_PRJ_TO_DATE_DRILLS_ALL is referenced by following:
|
|
|