[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PA_RPT_CUST_SUMMARY |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  PA.PA_RPT_CUST_SUMMARY
|
| Subobject Name: | |
| Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
PA_RPT_CUST_SUMMARY displays summary project level actual and budget information by customer for Oracle Discoverer Workbooks. All project amounts are divided among each of the customers of the project based on the customer bill split percentage. All Reporting Profiles must be set up at the site level of the application in order to use this view correctly. Specifically, all four Reporting Budget Type profiles need to be set up in order to return all the values from this view.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PROJECT_ID | NUMBER | (15) | The identifier of the project for which the amounts apply | |
| PROJECT_ACCUM_ID | NUMBER | (15) | The identifier which uniquely identifies this line for the actuals and budgets | |
| ACCUM_PERIOD | VARCHAR2 | (20) | Last accumulation GL or PA period, depending on the imp. option | |
| CUSTOMER_ID | NUMBER | (15) | The identifier of the customer that is involved with the project | |
| RAW_COST_ITD | NUMBER | Inception to date raw cost for project | ||
| RAW_COST_YTD | NUMBER | Year to date raw cost for project | ||
| RAW_COST_PTD | NUMBER | Period to date raw cost for PA or GL period | ||
| BILLABLE_RAW_COST_ITD | NUMBER | Inception to date billable raw cost for project | ||
| BILLABLE_RAW_COST_YTD | NUMBER | Year to date billable raw cost for project | ||
| BILLABLE_RAW_COST_PTD | NUMBER | Period to date billable raw cost for PA or GL period | ||
| BURDENED_COST_ITD | NUMBER | Inception to date burdened cost for project | ||
| BURDENED_COST_YTD | NUMBER | Year to date burdened cost for project | ||
| BURDENED_COST_PTD | NUMBER | Period to date burdened cost for PA or GL period | ||
| BILLABLE_BURDENED_COST_ITD | NUMBER | Inception to date billable burdened cost for project | ||
| BILLABLE_BURDENED_COST_YTD | NUMBER | Year to date billable burdened cost for project | ||
| BILLABLE_BURDENED_COST_PTD | NUMBER | Period to date billable burdened cost for PA or GL period | ||
| REVENUE_ITD | NUMBER | Inception to date revenue for project | ||
| REVENUE_YTD | NUMBER | Year to date revenue for project | ||
| REVENUE_PTD | NUMBER | Period to date revenue for PA or GL period | ||
| LABOR_HOURS_ITD | NUMBER | Inception to date labor hours for project | ||
| LABOR_HOURS_YTD | NUMBER | Year to date labor hours for project | ||
| LABOR_HOURS_PTD | NUMBER | Period to date labor hours for PA or GL period | ||
| BILLABLE_LABOR_HOURS_ITD | NUMBER | Inception to date billable labor hours for project | ||
| BILLABLE_LABOR_HOURS_YTD | NUMBER | Year to date billable labor hours for project | ||
| BILLABLE_LABOR_HOURS_PTD | NUMBER | Period to date billable labor hours for PA or GL period | ||
| BUDGET_TYPE_CODE1 | VARCHAR2 | (30) | The identifier of budget type for which this line was created | |
| BUDGET_TYPE1 | VARCHAR2 | (30) | The short, user-friendly name of the budget type | |
| BASE_RAW_COST_ITD1 | NUMBER | Inception to date base raw cost for project | ||
| BASE_RAW_COST_YTD1 | NUMBER | Year to date base raw cost for project | ||
| BASE_RAW_COST_PTD1 | NUMBER | Period to date base raw cost for PA or GL period | ||
| BASE_RAW_COST_TOT1 | NUMBER | Total base raw cost | ||
| ORIG_RAW_COST_ITD1 | NUMBER | Inception to date original raw cost for project | ||
| ORIG_RAW_COST_YTD1 | NUMBER | Year to date original raw cost for project | ||
| ORIG_RAW_COST_PTD1 | NUMBER | Period to date original raw cost for PA or GL period | ||
| ORIG_RAW_COST_TOT1 | NUMBER | Total original raw cost | ||
| BASE_BURDENED_COST_ITD1 | NUMBER | Inception to date base burdened cost for project | ||
| BASE_BURDENED_COST_YTD1 | NUMBER | Year to date base burdened cost for project | ||
| BASE_BURDENED_COST_PTD1 | NUMBER | Period to date base burdened cost for PA or GL period | ||
| BASE_BURDENED_COST_TOT1 | NUMBER | Total base burdened cost | ||
| ORIG_BURDENED_COST_ITD1 | NUMBER | Inception to date original burdened cost for project | ||
| ORIG_BURDENED_COST_YTD1 | NUMBER | Year to date original burdened cost for project | ||
| ORIG_BURDENED_COST_PTD1 | NUMBER | Period to date original burdened cost for PA or GL period | ||
| ORIG_BURDENED_COST_TOT1 | NUMBER | Total original burdened cost | ||
| ORIG_LABOR_HOURS_ITD1 | NUMBER | Inception to date original labor hours for project | ||
| ORIG_LABOR_HOURS_YTD1 | NUMBER | Year to date original labor hours for project | ||
| ORIG_LABOR_HOURS_PTD1 | NUMBER | Period to date original labor hours for PA or GL period | ||
| ORIG_LABOR_HOURS_TOT1 | NUMBER | Total original labor hours | ||
| BASE_LABOR_HOURS_ITD1 | NUMBER | Inception to date base labor hours for project | ||
| BASE_LABOR_HOURS_YTD1 | NUMBER | Year to date base labor hours for project | ||
| BASE_LABOR_HOURS_PTD1 | NUMBER | Period to date base labor hours for PA or GL period | ||
| BASE_LABOR_HOURS_TOT1 | NUMBER | Total base labor hours | ||
| BUDGET_TYPE_CODE2 | VARCHAR2 | (30) | The identifier of budget type for which this line was created | |
| BUDGET_TYPE2 | VARCHAR2 | (30) | The short, user-friendly name of the budget type | |
| BASE_RAW_COST_ITD2 | NUMBER | Inception to date base raw cost for project | ||
| BASE_RAW_COST_YTD2 | NUMBER | Year to date base raw cost for project | ||
| BASE_RAW_COST_PTD2 | NUMBER | Period to date base raw cost for PA or GL period | ||
| BASE_RAW_COST_TOT2 | NUMBER | Total base raw cost | ||
| ORIG_RAW_COST_ITD2 | NUMBER | Inception to date original raw cost for project | ||
| ORIG_RAW_COST_YTD2 | NUMBER | Year to date original raw cost for project | ||
| ORIG_RAW_COST_PTD2 | NUMBER | Period to date original raw cost for PA or GL period | ||
| ORIG_RAW_COST_TOT2 | NUMBER | Total original raw cost | ||
| BASE_BURDENED_COST_ITD2 | NUMBER | Inception to date base burdened cost for project | ||
| BASE_BURDENED_COST_YTD2 | NUMBER | Year to date base burdened cost for project | ||
| BASE_BURDENED_COST_PTD2 | NUMBER | Period to date base burdened cost for PA or GL period | ||
| BASE_BURDENED_COST_TOT2 | NUMBER | Total base burdened cost | ||
| ORIG_BURDENED_COST_ITD2 | NUMBER | Inception to date original burdened cost for project | ||
| ORIG_BURDENED_COST_YTD2 | NUMBER | Year to date original burdened cost for project | ||
| ORIG_BURDENED_COST_PTD2 | NUMBER | Period to date original burdened cost for PA or GL period | ||
| ORIG_BURDENED_COST_TOT2 | NUMBER | Total original burdened cost | ||
| ORIG_LABOR_HOURS_ITD2 | NUMBER | Inception to date original labor hours for project | ||
| ORIG_LABOR_HOURS_YTD2 | NUMBER | Year to date original labor hours for project | ||
| ORIG_LABOR_HOURS_PTD2 | NUMBER | Period to date original labor hours for PA or GL period | ||
| ORIG_LABOR_HOURS_TOT2 | NUMBER | Total original labor hours | ||
| BASE_LABOR_HOURS_ITD2 | NUMBER | Inception to date base labor hours for project | ||
| BASE_LABOR_HOURS_YTD2 | NUMBER | Year to date base labor hours for project | ||
| BASE_LABOR_HOURS_PTD2 | NUMBER | Period to date base labor hours for PA or GL period | ||
| BASE_LABOR_HOURS_TOT2 | NUMBER | Total base labor hours | ||
| BUDGET_TYPE_CODE3 | VARCHAR2 | (30) | The identifier of budget type for which this line was created | |
| BUDGET_TYPE3 | VARCHAR2 | (30) | The short, user-friendly name of the budget type | |
| BASE_REVENUE_ITD3 | NUMBER | Inception to date base revenue for project | ||
| BASE_REVENUE_YTD3 | NUMBER | Year to date base revenue for project | ||
| BASE_REVENUE_PTD3 | NUMBER | Period to date base revenue for PA or GL period | ||
| BASE_REVENUE_TOT3 | NUMBER | Total base revenue | ||
| ORIG_REVENUE_ITD3 | NUMBER | Inception to date original revenue for project | ||
| ORIG_REVENUE_YTD3 | NUMBER | Year to date original revenue for project | ||
| ORIG_REVENUE_PTD3 | NUMBER | Period to date original revenue for PA or GL period | ||
| ORIG_REVENUE_TOT3 | NUMBER | Total original revenue | ||
| ORIG_LABOR_HOURS_ITD3 | NUMBER | Inception to date original labor hours for project | ||
| ORIG_LABOR_HOURS_YTD3 | NUMBER | Year to date original labor hours for project | ||
| ORIG_LABOR_HOURS_PTD3 | NUMBER | Period to date original labor hours for PA or GL period | ||
| ORIG_LABOR_HOURS_TOT3 | NUMBER | Total original labor hours | ||
| BASE_LABOR_HOURS_ITD3 | NUMBER | Inception to date base labor hours for project | ||
| BASE_LABOR_HOURS_YTD3 | NUMBER | Year to date base labor hours for project | ||
| BASE_LABOR_HOURS_PTD3 | NUMBER | Period to date base labor hours for PA or GL period | ||
| BASE_LABOR_HOURS_TOT3 | NUMBER | Total base labor hours | ||
| BUDGET_TYPE_CODE4 | VARCHAR2 | (30) | The identifier of budget type for which this line was created | |
| BUDGET_TYPE4 | VARCHAR2 | (30) | The short, user-friendly name of the budget type | |
| BASE_REVENUE_ITD4 | NUMBER | Inception to date base revenue for project | ||
| BASE_REVENUE_YTD4 | NUMBER | Year to date base revenue for project | ||
| BASE_REVENUE_PTD4 | NUMBER | Period to date base revenue for PA or GL period | ||
| BASE_REVENUE_TOT4 | NUMBER | Total base revenue | ||
| ORIG_REVENUE_ITD4 | NUMBER | Inception to date original revenue for project | ||
| ORIG_REVENUE_YTD4 | NUMBER | Year to date original revenue for project | ||
| ORIG_REVENUE_PTD4 | NUMBER | Period to date original revenue for PA or GL period | ||
| ORIG_REVENUE_TOT4 | NUMBER | Total original revenue | ||
| ORIG_LABOR_HOURS_ITD4 | NUMBER | Inception to date original labor hours for project | ||
| ORIG_LABOR_HOURS_YTD4 | NUMBER | Year to date original labor hours for project | ||
| ORIG_LABOR_HOURS_PTD4 | NUMBER | Period to date original labor hours for PA or GL period | ||
| ORIG_LABOR_HOURS_TOT4 | NUMBER | Total original labor hours | ||
| BASE_LABOR_HOURS_ITD4 | NUMBER | Inception to date base labor hours for project | ||
| BASE_LABOR_HOURS_YTD4 | NUMBER | Year to date base labor hours for project | ||
| BASE_LABOR_HOURS_PTD4 | NUMBER | Period to date base labor hours for PA or GL period | ||
| BASE_LABOR_HOURS_TOT4 | NUMBER | Total base labor hours |
Cut, paste (and edit) the following text to query this object:
SELECT PROJECT_ID
, PROJECT_ACCUM_ID
, ACCUM_PERIOD
, CUSTOMER_ID
, RAW_COST_ITD
, RAW_COST_YTD
, RAW_COST_PTD
, BILLABLE_RAW_COST_ITD
, BILLABLE_RAW_COST_YTD
, BILLABLE_RAW_COST_PTD
, BURDENED_COST_ITD
, BURDENED_COST_YTD
, BURDENED_COST_PTD
, BILLABLE_BURDENED_COST_ITD
, BILLABLE_BURDENED_COST_YTD
, BILLABLE_BURDENED_COST_PTD
, REVENUE_ITD
, REVENUE_YTD
, REVENUE_PTD
, LABOR_HOURS_ITD
, LABOR_HOURS_YTD
, LABOR_HOURS_PTD
, BILLABLE_LABOR_HOURS_ITD
, BILLABLE_LABOR_HOURS_YTD
, BILLABLE_LABOR_HOURS_PTD
, BUDGET_TYPE_CODE1
, BUDGET_TYPE1
, BASE_RAW_COST_ITD1
, BASE_RAW_COST_YTD1
, BASE_RAW_COST_PTD1
, BASE_RAW_COST_TOT1
, ORIG_RAW_COST_ITD1
, ORIG_RAW_COST_YTD1
, ORIG_RAW_COST_PTD1
, ORIG_RAW_COST_TOT1
, BASE_BURDENED_COST_ITD1
, BASE_BURDENED_COST_YTD1
, BASE_BURDENED_COST_PTD1
, BASE_BURDENED_COST_TOT1
, ORIG_BURDENED_COST_ITD1
, ORIG_BURDENED_COST_YTD1
, ORIG_BURDENED_COST_PTD1
, ORIG_BURDENED_COST_TOT1
, ORIG_LABOR_HOURS_ITD1
, ORIG_LABOR_HOURS_YTD1
, ORIG_LABOR_HOURS_PTD1
, ORIG_LABOR_HOURS_TOT1
, BASE_LABOR_HOURS_ITD1
, BASE_LABOR_HOURS_YTD1
, BASE_LABOR_HOURS_PTD1
, BASE_LABOR_HOURS_TOT1
, BUDGET_TYPE_CODE2
, BUDGET_TYPE2
, BASE_RAW_COST_ITD2
, BASE_RAW_COST_YTD2
, BASE_RAW_COST_PTD2
, BASE_RAW_COST_TOT2
, ORIG_RAW_COST_ITD2
, ORIG_RAW_COST_YTD2
, ORIG_RAW_COST_PTD2
, ORIG_RAW_COST_TOT2
, BASE_BURDENED_COST_ITD2
, BASE_BURDENED_COST_YTD2
, BASE_BURDENED_COST_PTD2
, BASE_BURDENED_COST_TOT2
, ORIG_BURDENED_COST_ITD2
, ORIG_BURDENED_COST_YTD2
, ORIG_BURDENED_COST_PTD2
, ORIG_BURDENED_COST_TOT2
, ORIG_LABOR_HOURS_ITD2
, ORIG_LABOR_HOURS_YTD2
, ORIG_LABOR_HOURS_PTD2
, ORIG_LABOR_HOURS_TOT2
, BASE_LABOR_HOURS_ITD2
, BASE_LABOR_HOURS_YTD2
, BASE_LABOR_HOURS_PTD2
, BASE_LABOR_HOURS_TOT2
, BUDGET_TYPE_CODE3
, BUDGET_TYPE3
, BASE_REVENUE_ITD3
, BASE_REVENUE_YTD3
, BASE_REVENUE_PTD3
, BASE_REVENUE_TOT3
, ORIG_REVENUE_ITD3
, ORIG_REVENUE_YTD3
, ORIG_REVENUE_PTD3
, ORIG_REVENUE_TOT3
, ORIG_LABOR_HOURS_ITD3
, ORIG_LABOR_HOURS_YTD3
, ORIG_LABOR_HOURS_PTD3
, ORIG_LABOR_HOURS_TOT3
, BASE_LABOR_HOURS_ITD3
, BASE_LABOR_HOURS_YTD3
, BASE_LABOR_HOURS_PTD3
, BASE_LABOR_HOURS_TOT3
, BUDGET_TYPE_CODE4
, BUDGET_TYPE4
, BASE_REVENUE_ITD4
, BASE_REVENUE_YTD4
, BASE_REVENUE_PTD4
, BASE_REVENUE_TOT4
, ORIG_REVENUE_ITD4
, ORIG_REVENUE_YTD4
, ORIG_REVENUE_PTD4
, ORIG_REVENUE_TOT4
, ORIG_LABOR_HOURS_ITD4
, ORIG_LABOR_HOURS_YTD4
, ORIG_LABOR_HOURS_PTD4
, ORIG_LABOR_HOURS_TOT4
, BASE_LABOR_HOURS_ITD4
, BASE_LABOR_HOURS_YTD4
, BASE_LABOR_HOURS_PTD4
, BASE_LABOR_HOURS_TOT4
FROM APPS.PA_RPT_CUST_SUMMARY;
APPS
PA_RPT_CUST_SUMMARY_BASE_V
PA_RPT_UTILS
- show dependent code
APPS.PA_RPT_CUST_SUMMARY is not referenced by any database object
|
|
|
|