DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.PA_PROJ_UNBILLED_EXPEND_VIEW

Object Details
Object Name: PA_PROJ_UNBILLED_EXPEND_VIEW
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPA.PA_PROJ_UNBILLED_EXPEND_VIEW
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


PA_PROJ_UNBILLED_EXPEND_VIEW is a view that displays billable
expenditure items that are unbilled. You can review the unbilled
expenditure items for your projects using this view.
.
.


[View Source]

Columns
Name Datatype Length Mandatory Comments
PROJECT_ID NUMBER (15) Yes Identifier of the project charged
ON_HOLD_FLAG VARCHAR2 (80)
Indicator if the expenditure item is on hold. Values are Yes, No, or Once.
EMPLOYEE_VENDOR_NAME VARCHAR2 (240)
Name of the employee or the vendor. This value is the vendor for vendor invoice items, and the employee for labor, expense report, and usage items
EMPLOYEE_VENDOR_NUM VARCHAR2 (30)
Number of the employee or the vendor. This value is the vendor number of vendor invoice items and employee number for labor, expense report, and usage items
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 overrides for labor, expense report, and usage items. For vendor invoice items, this is the expenditure organization as entered in Payables
ORGANIZATION_NAME VARCHAR2 (4000)
Name of the organization incurring the expenditure item. This column displays the override_to_organization if specified, else displays the incurred by organization as entered on the expenditure
JOB_RESOURCE_ORG_NAME VARCHAR2 (4000)
Job billing title for labor and expense report items, blank for vendor invoice items, and non-labor resource concatenated with resource organization name for usage items
EXPENDITURE_TYPE VARCHAR2 (30) Yes Expenditure type of the expenditure item
TASK_NUMBER VARCHAR2 (25) Yes Number 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. This column is not populated if (1) a markup percentage or labor multipler was used to calculate T and M revenue or (2) if revenue is accrued under a Cost/Cost or Cost/Event distribution rule
BILL_AMOUNT NUMBER (22)
Amount to be billed for the expenditure item
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 Ei
BILL_TRANS_BILL_AMOUNT NUMBER

This is the bill amount in bill transaction currency
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PROJECT_ID
,      ON_HOLD_FLAG
,      EMPLOYEE_VENDOR_NAME
,      EMPLOYEE_VENDOR_NUM
,      INCURRED_BY_ORGANIZATION_ID
,      OVERRIDE_TO_ORGANIZATION_ID
,      ORGANIZATION_NAME
,      JOB_RESOURCE_ORG_NAME
,      EXPENDITURE_TYPE
,      TASK_NUMBER
,      EXPENDITURE_ITEM_DATE
,      QUANTITY
,      UNIT_OF_MEASURE
,      BILL_RATE
,      BILL_AMOUNT
,      INVPROC_CURRENCY_CODE
,      BILL_TRANS_CURRENCY_CODE
,      BILL_TRANS_BILL_AMOUNT
FROM APPS.PA_PROJ_UNBILLED_EXPEND_VIEW;

Dependencies

[top of page]

APPS.PA_PROJ_UNBILLED_EXPEND_VIEW references the following:

SchemaAPPS
SynonymPA_CUST_REV_DIST_LINES
SynonymPA_DRAFT_INVOICE_ITEMS
PL/SQL PackagePA_EXPENDITURES_UTILS - show dependent code
SynonymPA_EXPENDITURE_ITEMS_ALL
ViewPA_PROJ_EXPEND_VIEW
PL/SQL PackagePA_UTILS4 - show dependent code

APPS.PA_PROJ_UNBILLED_EXPEND_VIEW is not referenced by any database object