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_COST_EXPEND_VIEW

Object Details

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

View Type

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

View of transactions for Project Costing projects, including quantities and cost amounts.

[View Source]

Columns

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
INCURRED_BY_EMPLOYEE_NAME	VARCHAR2	(240)		Full name of the employee incurring the charge; this column is always populated for labor and expense report items, and optionally for usage items. This column is always blank for vendor invoice items
INCURRED_BY_EMPLOYEE_NUM	VARCHAR2	(30)		Number of the employee incurring the charge. this column is always populated for labor and expense report items, and optionally for usage items. This column is always blank for vendor invoice items
INCURRED_BY_PERSON_ID	NUMBER	(15)		Identifier of the employee incurring the charge. This column is always populated for labor and expense report items, and optionally for usage items. This column is always blank for vendor invoice items
VENDOR_ID	NUMBER			Identifier of the vendor of the vendor invoice item; this value is blank for other types of charges
VENDOR_NUM	VARCHAR2	(30)		Number of the vendor. This column is always populated for vendor invoice items; this value is blank for other types of charges
VENDOR_NAME	VARCHAR2	(240)		Name of the vendor. This column is always populated for vendor invoice items; this value is blank for other types of charges
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 vendor. This value is the vendor number of vendor invoice items and the employee number for labor, expense report, and usage items
INCURRED_BY_ORGANIZATION_ID	NUMBER	(15)		Identifier of the organization incurring the expenditure item
INCURRED_BY_ORGANIZATION_NAME	VARCHAR2	(240)		Name of the organization incurring the expenditure item
JOB_ID	NUMBER	(15)		Identifier of the costing job for the expenditure item
JOB_NAME	VARCHAR2	(700)		Name of the costing job for the expenditure item
JOB_RESOURCE_ORG_NAME	VARCHAR2	(700)		Job name for labor and expense report items, blank for vendor invoices, and non-labor resouce concatenated with the resource organization name for usage items
EXPENDITURE_TYPE	VARCHAR2	(30)	Yes	Expenditure type of the expenditure item
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
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. Also referred to as direct cost
BURDEN_COST	NUMBER			Total burdened cost of the expenditure item. BURDENED COST = RAW COST + BURDEN
COST_DISTRIBUTED_FLAG	VARCHAR2	(1)	Yes	Flag that indicates whether the item has been cost distributed. Upon entry, the flag is set to N. When the item is cost distributed, the flag is set to Y
NON_LABOR_RESOURCE	VARCHAR2	(20)		Non-labor resource utilized as the work was performed. This column is only populated for usage items
RESOURCE_ORGANIZATION_ID	NUMBER	(15)		Identifier of the organization that owns the resource that was utilized when the work was performed. This column is only populated for usage items
RESOURCE_ORGANIZATION_NAME	VARCHAR2	(240)		Name of the organization that owns the resource that was utilized when the work was performed. This column is only populated for usage items

Query Text

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


SELECT EXPENDITURE_ITEM_ID
,      PROJECT_ID
,      INCURRED_BY_EMPLOYEE_NAME
,      INCURRED_BY_EMPLOYEE_NUM
,      INCURRED_BY_PERSON_ID
,      VENDOR_ID
,      VENDOR_NUM
,      VENDOR_NAME
,      EMPLOYEE_VENDOR_NAME
,      EMPLOYEE_VENDOR_NUM
,      INCURRED_BY_ORGANIZATION_ID
,      INCURRED_BY_ORGANIZATION_NAME
,      JOB_ID
,      JOB_NAME
,      JOB_RESOURCE_ORG_NAME
,      EXPENDITURE_TYPE
,      TASK_ID
,      TASK_NUMBER
,      EXPENDITURE_ITEM_DATE
,      QUANTITY
,      UNIT_OF_MEASURE
,      RAW_COST
,      BURDEN_COST
,      COST_DISTRIBUTED_FLAG
,      NON_LABOR_RESOURCE
,      RESOURCE_ORGANIZATION_ID
,      RESOURCE_ORGANIZATION_NAME
FROM APPS.PA_PROJ_COST_EXPEND_VIEW;

Dependencies

[top of page]

APPS.PA_PROJ_COST_EXPEND_VIEW references the following:

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_COST_DISTRIBUTION_LINES_ALL; PA_EXPENDITURES_ALL; PA_EXPENDITURE_ITEMS_ALL; PA_EXPENDITURE_TYPES; PA_LOOKUPS; PA_TASKS; PER_JOBS; PER_PEOPLE_F; PO_VENDORS

APPS.PA_PROJ_COST_EXPEND_VIEW is not referenced by any database object