[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PA_PROJ_EXPEND_VIEW |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  PA.PA_PROJ_EXPEND_VIEW
|
| Subobject Name: | |
| Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
Expenditure items for projects, which includes cost and revenue.
PA_PROJ_EXPEND_VIEW is a view of all project expenditure items. This view displays all relevant information for all expenditure items, including labor, expense reports, usages, and supplier invoices. You can use this view to easily report project expenditure items.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| EXPENDITURE_ITEM_ID | NUMBER | (15) | Yes | Identifier of the expenditure item |
| PROJECT_ID | NUMBER | (15) | Yes | Identifier of the project charged |
| PROJECT_NUM | VARCHAR2 | (25) | Yes | Number of the project charged |
| PROJECT_NAME | VARCHAR2 | (30) | Yes | Name of the project charged |
| ON_HOLD_FLAG | VARCHAR2 | (80) | Indicator if the expenditure item is on hold. Values are Yes, No, or Once. | |
| ON_HOLD_CODE | VARCHAR2 | (1) | Yes | Code of the hold flag. Holds N, Y, or O (for Once) |
| INCURRED_BY_EMPLOYEE_NAME | VARCHAR2 | (240) | Full name of the employee incurring the charge | |
| INCURRED_BY_EMPLOYEE_NUM | VARCHAR2 | (30) | Number of the employee incurring the charge. | |
| INCURRED_BY_PERSON_ID | NUMBER | (15) | Identifier of the employee incurring the charge. | |
| VENDOR_ID | NUMBER | Identifier of the vendor of the vendor invoice item | ||
| VENDOR_NUM | VARCHAR2 | (30) | Number of the vendor. This column is always populated for vendor invoice items | |
| VENDOR_NAME | VARCHAR2 | (240) | Name of the vendor. This column is always populated for vendor invoice items | |
| EMPLOYEE_VENDOR_NAME | VARCHAR2 | (240) | Name of the employee or the vendor. | |
| EMPLOYEE_VENDOR_NUM | VARCHAR2 | (30) | Number of the employee or the vendor | |
| EMPLOYEE_PERSON_ID | NUMBER | (10) | Identifier of the person that incurred the charge | |
| INCURRED_BY_ORGANIZATION_ID | NUMBER | (15) | Identifier of the organization incurring the expenditure item | |
| OVERRIDE_TO_ORGANIZATION_ID | NUMBER | (15) | Identifier of the destination organization resulting from cost distribution | |
| INCURRED_BY_ORGANIZATION_NAME | VARCHAR2 | (4000) | Name of the organization incurring the expenditure item | |
| JOB_ID | NUMBER | Identifier of the job that is effective for the item. | ||
| JOB_NAME | VARCHAR2 | (700) | Effective job billing title. for labor items processed for revenue accrual | |
| JOB_RESOURCE_ORG_NAME | VARCHAR2 | (4000) | Job billing title for labor and expense report items, blank for vendor invoice items | |
| EXPENDITURE_TYPE | VARCHAR2 | (30) | Yes | Expenditure type of the expenditure item |
| EXPENDITURE_CATEGORY | VARCHAR2 | (30) | Yes | Expenditure category of the expenditure type |
| SYSTEM_LINKAGE_FUNCTION | VARCHAR2 | (3) | Yes | System linkage function of the expenditure type |
| TASK_ID | NUMBER | (15) | Yes | Identifier of the lowest level task incurring the charge |
| TASK_NUMBER | VARCHAR2 | (25) | Yes | Number of lowest level task incurring the charge |
| TASK_NAME | VARCHAR2 | (20) | Yes | Name of lowest level task incurring the charge |
| EXPENDITURE_ITEM_DATE | DATE | Yes | Expenditure item date | |
| QUANTITY | NUMBER | Quantity of units of work performed | ||
| UNIT_OF_MEASURE | VARCHAR2 | (4000) | Unit of measure of the expenditure type | |
| BILL_RATE | NUMBER | (22) | Bill rate of the expenditure item | |
| BILL_AMOUNT | NUMBER | (22) | Amount to be billed for the expenditure item | |
| 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 | ||
| 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 | |
| COST_DISTRIBUTED_FLAG | VARCHAR2 | (1) | Yes | Flag that indicates whether the item has been cost distributed |
| REVENUE_DISTRIBUTED_FLAG | VARCHAR2 | (1) | Yes | Flag that indicates whether the item is revenue distributed. |
| BILLABLE_FLAG | VARCHAR2 | (1) | Yes | Flag that indicates if the item can accrue revenue |
| NON_LABOR_RESOURCE | VARCHAR2 | (20) | Non-labor resource utilized as the work was performed | |
| RESOURCE_ORGANIZATION_ID | NUMBER | (15) | Identifier of the organization that owns the resource that was utilized | |
| RESOURCE_ORGANIZATION_NAME | VARCHAR2 | (4000) | Name of the organization that owns the resource that was utilized | |
| SYSTEM_REFERENCE2 | VARCHAR2 | (30) | System reference2 obsoleted | |
| SYSTEM_REFERENCE3 | VARCHAR2 | (30) | System reference3 obsoleted | |
| PRIMARY_FLAG | VARCHAR2 | (30) | Flag which indicates whether it is a primary assignment or not | |
| 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_BURDENED_COST | NUMBER | Burdend cost in project currency | ||
| PROJECT_CURRENCY_CODE | VARCHAR2 | (15) | Project currency code | |
| PROJECT_RATE_DATE | DATE | Conversion type 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 type used to convert raw cost in transaction currency to project currency | ||
| INVPROC_CURRENCY_CODE | VARCHAR2 | (15) | The invoice processing currency code | |
| BILL_TRANS_CURRENCY_CODE | VARCHAR2 | (15) | This is the currency code for the bill amount on Eis | |
| BILL_TRANS_BILL_AMOUNT | NUMBER | This is the bill amount in bill transaction currency | ||
| DOCUMENT_HEADER_ID | NUMBER | (15) | Document_header_id holds the invoice ID for supplier invoice_items | |
| DOCUMENT_DISTRIBUTION_ID | NUMBER | (15) | Document_distribution_id holds the invoice distribution Identifier for supplier invoice items | |
| DOCUMENT_PAYMENT_ID | NUMBER | (15) | Document_payment_id holds the invoice Payment ID for supplier invoice items | |
| DOCUMENT_LINE_NUMBER | NUMBER | (15) | Document_line_number holds the invoice line number for supplier invoice items | |
| DOCUMENT_TYPE | VARCHAR2 | (30) | Document_type holds the document type for supplier invoice Items | |
| DOCUMENT_DISTRIBUTION_TYPE | VARCHAR2 | (30) | Document_distribution_type holds the Distribution type such as NRTAX for supplier invoice items | |
| ORG_ID | NUMBER | (15) | Org_id holds the internal identifier of the Operating Unit for the project used in the expenditure item | |
| EVENT_NUM | NUMBER | (15) | The event number of the payment schedule event that fifo (first in-first out) marks the expenditure item as invoiced for an event billing project |
Cut, paste (and edit) the following text to query this object:
SELECT EXPENDITURE_ITEM_ID
, PROJECT_ID
, PROJECT_NUM
, PROJECT_NAME
, ON_HOLD_FLAG
, ON_HOLD_CODE
, INCURRED_BY_EMPLOYEE_NAME
, INCURRED_BY_EMPLOYEE_NUM
, INCURRED_BY_PERSON_ID
, VENDOR_ID
, VENDOR_NUM
, VENDOR_NAME
, EMPLOYEE_VENDOR_NAME
, EMPLOYEE_VENDOR_NUM
, EMPLOYEE_PERSON_ID
, INCURRED_BY_ORGANIZATION_ID
, OVERRIDE_TO_ORGANIZATION_ID
, INCURRED_BY_ORGANIZATION_NAME
, JOB_ID
, JOB_NAME
, JOB_RESOURCE_ORG_NAME
, EXPENDITURE_TYPE
, EXPENDITURE_CATEGORY
, SYSTEM_LINKAGE_FUNCTION
, TASK_ID
, TASK_NUMBER
, TASK_NAME
, EXPENDITURE_ITEM_DATE
, QUANTITY
, UNIT_OF_MEASURE
, BILL_RATE
, BILL_AMOUNT
, RAW_COST
, BURDEN_COST
, POTENTIAL_REVENUE
, ACCRUED_REVENUE
, COST_DISTRIBUTED_FLAG
, REVENUE_DISTRIBUTED_FLAG
, BILLABLE_FLAG
, NON_LABOR_RESOURCE
, RESOURCE_ORGANIZATION_ID
, RESOURCE_ORGANIZATION_NAME
, SYSTEM_REFERENCE2
, SYSTEM_REFERENCE3
, PRIMARY_FLAG
, 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_BURDENED_COST
, PROJECT_CURRENCY_CODE
, PROJECT_RATE_DATE
, PROJECT_RATE_TYPE
, PROJECT_EXCHANGE_RATE
, INVPROC_CURRENCY_CODE
, BILL_TRANS_CURRENCY_CODE
, BILL_TRANS_BILL_AMOUNT
, DOCUMENT_HEADER_ID
, DOCUMENT_DISTRIBUTION_ID
, DOCUMENT_PAYMENT_ID
, DOCUMENT_LINE_NUMBER
, DOCUMENT_TYPE
, DOCUMENT_DISTRIBUTION_TYPE
, ORG_ID
, EVENT_NUM
FROM APPS.PA_PROJ_EXPEND_VIEW;
APPS
PA_COST_DIST_LINES_ALL_BAS
PA_EXPENDITURES_ALL
PA_EXPENDITURES_UTILS
- show dependent code
PA_EXPENDITURE_ITEMS_ALL
PA_EXPENDITURE_TYPES
PA_LOOKUPS
PA_PROJECTS
PA_TASKS
PA_UTILS4
- show dependent code
PER_ALL_ASSIGNMENTS_F
PER_ALL_PEOPLE_F
PER_JOBS
PO_VENDORS
APPS
PA_PROJ_ADJUSTMENTS_VIEW
PA_PROJ_INVOICE_DETAILS_VIEW
PA_PROJ_UNBILLED_EXPEND_VIEW
|
|
|
|