[Home] [Help] [Dependency Information]
Object Name: | PA_BIS_PRJ_BY_PRD_DRILLS_ALL |
---|---|
Object Type: | TABLE |
Owner: | PA |
FND Design Data: | PA.PA_BIS_PRJ_BY_PRD_DRILLS_ALL |
Subobject Name: | |
Status: | VALID |
PA_BIS_PRJ_BY_PRD_DRILLS_ALL stores the data to be reported by the Oracle Business Intelligence Systems reports for Oracle Projects. The data is stored for projects, for various drilldowns, categorized by various columns and shown.
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PA_BIS_PRJ_BY_PERD_DRLDNS_N1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY |
DRILLDOWN_TYPE
AMOUNT_TYPE_CODE PROJECT_ID |
PA_BIS_PRJ_BY_PERD_DRLDNS_N2 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY |
DRILLDOWN_KEY1
DRILLDOWN_KEY2 |
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 | |
PROJECT_ID | NUMBER | The identifier of the project | ||
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 | |
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 for the period | ||
END_DATE | DATE | The end date for 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 |
Cut, paste (and edit) the following text to query this object:
SELECT DRILLDOWN_TYPE
, AMOUNT_TYPE_CODE
, PROJECT_ID
, DRILLDOWN_KEY1
, DRILLDOWN_KEY2
, DRILLDOWN_KEY3
, PERIOD_NAME
, ACCUMULATION_PERIOD_TYPE
, START_DATE
, END_DATE
, SORT_ORDER
, ACTUAL
, BUDGET
, ORG_ID
FROM PA.PA_BIS_PRJ_BY_PRD_DRILLS_ALL;
PA.PA_BIS_PRJ_BY_PRD_DRILLS_ALL does not reference any database object
PA.PA_BIS_PRJ_BY_PRD_DRILLS_ALL is referenced by following:
|
|
|