[Home] [Help] [Dependency Information]
Object Name: | PA_BIS_TOTALS_BY_PRD_ALL |
---|---|
Object Type: | TABLE |
Owner: | PA |
FND Design Data: | PA.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.
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PA_BIS_TOTALS_BY_PERIOD_N1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | AMOUNT_TYPE_CODE |
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 |
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;
PA.PA_BIS_TOTALS_BY_PRD_ALL does not reference any database object
PA.PA_BIS_TOTALS_BY_PRD_ALL is referenced by following:
|
|
|