[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PA_PROJ_TRANSFERS_VIEW |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  PA.PA_PROJ_TRANSFERS_VIEW
|
| Subobject Name: | |
| Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
PA_PROJ_TRANSFERS_VIEW is a view that displays transferred expenditure items, including the original and destination project and task of the transfer.
You can easily use this view to report transfers between projects.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| TO_PROJECT_ID | NUMBER | (15) | Yes | Identifier of the project that the item was transferred to |
| TO_PROJECT_NUM | VARCHAR2 | (25) | Yes | Number of the project that the item was transferred to |
| TO_PROJECT_NAME | VARCHAR2 | (30) | Yes | Name of the project that the item was transferred to |
| TO_TASK_ID | NUMBER | (15) | Yes | Identifier of the lowest level task that the item was transferred to |
| TO_TASK_NUMBER | VARCHAR2 | (25) | Yes | Number of the lowest level task that the item was transferred to |
| TO_TASK_NAME | VARCHAR2 | (20) | Yes | Name of the lowest level task that the item was transferred to |
| TO_EXPENDITURE_ITEM_ID | NUMBER | (15) | Yes | Identifier of the new expenditure item charged to the new project resulting from the transfer |
| FROM_PROJECT_ID | NUMBER | (15) | Yes | Identifier of the project that the item was transferred from |
| FROM_PROJECT_NUM | VARCHAR2 | (25) | Yes | Number of the project that the item was transferred from |
| FROM_PROJECT_NAME | VARCHAR2 | (30) | Yes | Name of the project that the item was transferred from |
| FROM_TASK_ID | NUMBER | (15) | Yes | Identifier of the lowest level task that the item was transferred from |
| FROM_TASK_NAME | VARCHAR2 | (20) | Yes | Name of the lowest level task that the item was transferred from |
| FROM_TASK_NUMBER | VARCHAR2 | (25) | Yes | Number of the lowest level task that the item was transferred from |
| TRANSFERRED_FROM_EXP_ITEM_ID | NUMBER | (15) | Identifier of the original expenditure item that was transferred from the original project and task to a new project and task | |
| INCURRED_BY_PERSON_ID | NUMBER | (15) | Identifier of the employee incurring the charge | |
| INCURRED_BY_EMPLOYEE_NUM | VARCHAR2 | (30) | Number of the employee incurring the charge | |
| INCURRED_BY_NAME | VARCHAR2 | (240) | Full name of the employee incurring the charge | |
| ORGANIZATION_ID | NUMBER | (15) | Identifier of the organization incurring the charge | |
| ORGANIZATION_NAME | VARCHAR2 | (240) | Name of the organization incurring the charge | |
| EXPENDITURE_TYPE | VARCHAR2 | (30) | Yes | Expenditure type of the expenditure item |
| EXPENDITURE_ITEM_DATE | DATE | Yes | Expenditure item date | |
| QUANTITY | NUMBER | Quantity of units of work performed | ||
| UNIT_OF_MEASURE | VARCHAR2 | (80) | Yes | Unit of measure of the expenditure type |
| RAW_COST | NUMBER | Total raw cost of the expenditure item in project currency. Also referred to as direct cost | ||
| BURDEN_COST | NUMBER | Total burdened cost of the expenditure item in project currency. BURDENED COST = RAW COST + BURDEN | ||
| POTENTIAL_REVENUE | NUMBER | Potential revenue of the item | ||
| ACCRUED_REVENUE | NUMBER | (22) | Total accrued revenue of the item. This amount is different from the potential revenue if the project hit a hard funding limit | |
| DENOM_CURRENCY_CODE | VARCHAR2 | (15) | Transaction currency code | |
| DENOM_RAW_COST | NUMBER | Raw cost in transaction currency | ||
| DENOM_BURDENED_COST | NUMBER | Burdened cost in transaction currency | ||
| ACCT_CURRENCY_CODE | VARCHAR2 | (15) | Functional currency code | |
| ACCT_RATE_DATE | DATE | Conversion date used to convert raw cost in transaction currency to functional currency | ||
| ACCT_RATE_TYPE | VARCHAR2 | (30) | Conversion type used to convert raw cost in transaction currency to functional currency | |
| ACCT_EXCHANGE_RATE | NUMBER | Conversion rate used to convert raw cost in transaction currency to functional currency | ||
| ACCT_RAW_COST | NUMBER | Raw cost in functional currency | ||
| ACCT_BURDENED_COST | NUMBER | Burdened cost in functional currency | ||
| PROJECT_CURRENCY_CODE | VARCHAR2 | (15) | Project currency code | |
| PROJECT_RATE_DATE | DATE | Conversion date used to convert raw cost in transaction currency to project currency | ||
| PROJECT_RATE_TYPE | VARCHAR2 | (30) | Conversion type used to convert raw cost in transaction currency to project currency | |
| PROJECT_EXCHANGE_RATE | NUMBER | Conversion rate used to convert raw cost in transaction currency to project currency | ||
| ORG_ID | NUMBER | (15) | Operating Unit Identifier |
Cut, paste (and edit) the following text to query this object:
SELECT TO_PROJECT_ID
, TO_PROJECT_NUM
, TO_PROJECT_NAME
, TO_TASK_ID
, TO_TASK_NUMBER
, TO_TASK_NAME
, TO_EXPENDITURE_ITEM_ID
, FROM_PROJECT_ID
, FROM_PROJECT_NUM
, FROM_PROJECT_NAME
, FROM_TASK_ID
, FROM_TASK_NAME
, FROM_TASK_NUMBER
, TRANSFERRED_FROM_EXP_ITEM_ID
, INCURRED_BY_PERSON_ID
, INCURRED_BY_EMPLOYEE_NUM
, INCURRED_BY_NAME
, ORGANIZATION_ID
, ORGANIZATION_NAME
, EXPENDITURE_TYPE
, EXPENDITURE_ITEM_DATE
, QUANTITY
, UNIT_OF_MEASURE
, RAW_COST
, BURDEN_COST
, POTENTIAL_REVENUE
, ACCRUED_REVENUE
, DENOM_CURRENCY_CODE
, DENOM_RAW_COST
, DENOM_BURDENED_COST
, ACCT_CURRENCY_CODE
, ACCT_RATE_DATE
, ACCT_RATE_TYPE
, ACCT_EXCHANGE_RATE
, ACCT_RAW_COST
, ACCT_BURDENED_COST
, PROJECT_CURRENCY_CODE
, PROJECT_RATE_DATE
, PROJECT_RATE_TYPE
, PROJECT_EXCHANGE_RATE
, ORG_ID
FROM APPS.PA_PROJ_TRANSFERS_VIEW;
APPS
HR_ALL_ORGANIZATION_UNITS_TL
HR_GENERAL
- show dependent code
HR_ORG_UNITS_NO_JOIN
HR_PERSON_NAME
- show dependent code
HR_SECURITY
- show dependent code
PA_EXPENDITURES_ALL
PA_EXPENDITURE_ITEMS_ALL
PA_EXPENDITURE_TYPES
PA_LOOKUPS
PA_PROJECTS
PA_PROJECTS_ALL
PA_TASKS
PER_PEOPLE_F
APPS.PA_PROJ_TRANSFERS_VIEW is not referenced by any database object
|
|
|
|