eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.PA_PROJ_INVOICE_DETAILS_VIEW

Object Details

Object Name:	PA_PROJ_INVOICE_DETAILS_VIEW
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PA_PROJ_INVOICE_DETAILS_VIEW
Subobject Name:
Status:	VALID

View Type

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

View of detail expenditure items included on project invoices.
Full Description: is a view that displays the detailed expenditure items that backup
a project invoice. You can use this view to easily report the expenditure item information
for a invoice backup report.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PROJECT_ID	NUMBER	(15)	Yes	Identifier of the project
EXPENDITURE_ITEM_ID	NUMBER	(15)	Yes	Identifier of the expenditure item
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
ORGANIZATION_ID	NUMBER	(15)		Identifier of the organization incurring the expenditure item
ORGANIZATION_NAME	VARCHAR2	(4000)		Name of the organization incurring the expenditure item
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			Bill rate of the item. This column is blank if (1) a markup percentage or labor multipler was used to calculate T M revenue or (2) if revenue is accrued under a Cost/Cost or Cost/Event distribution rule or (3) it is on a crediting invoice
BILL_AMOUNT	NUMBER	(22)		Amount to be billed for the expenditure item on the draft invoice. If the item is billed on more than one invoice, the bill rate * quantity of the item will not equal this bill amount
DRAFT_INVOICE_NUM	NUMBER	(15)		Draft invoice number that the item is billed on
DRAFT_INVOICE_ITEM_LINE_NUM	NUMBER	(15)		Draft invoice line number that the item is billed on

Query Text

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


SELECT PROJECT_ID
,      EXPENDITURE_ITEM_ID
,      EMPLOYEE_VENDOR_NAME
,      EMPLOYEE_VENDOR_NUM
,      ORGANIZATION_ID
,      ORGANIZATION_NAME
,      JOB_RESOURCE_ORG_NAME
,      EXPENDITURE_TYPE
,      TASK_NUMBER
,      EXPENDITURE_ITEM_DATE
,      QUANTITY
,      UNIT_OF_MEASURE
,      BILL_RATE
,      BILL_AMOUNT
,      DRAFT_INVOICE_NUM
,      DRAFT_INVOICE_ITEM_LINE_NUM
FROM APPS.PA_PROJ_INVOICE_DETAILS_VIEW;

Dependencies

[top of page]

APPS.PA_PROJ_INVOICE_DETAILS_VIEW references the following:

APPS: PA_CUST_REV_DIST_LINES; PA_DRAFT_INVOICE_ITEMS; PA_EXPENDITURES_UTILS - show dependent code; PA_PROJ_EXPEND_VIEW; PA_UTILS4 - show dependent code

APPS.PA_PROJ_INVOICE_DETAILS_VIEW is referenced by following:

APPS: PA_ADJUSTMENTS - show dependent code