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.PJM_PROJECT_EXPEND_V

Object Details

Object Name:	PJM_PROJECT_EXPEND_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PJM.PJM_PROJECT_EXPEND_V
Subobject Name:
Status:	VALID

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.

PJM_PROJECT_EXPEND_V returns expenditure details for each project.
This view corresponds to the Expenditure Info web inquiry region.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PROJECT_ID	NUMBER	(15)	Yes	System-generated number that uniquely identifies a project
TASK_ID	NUMBER	(15)	Yes	System-generated number that uniquely identifies a task
TASK_NUMBER	VARCHAR2	(25)	Yes	User-entered string that uniquely identifies a task within a project
EXPENDITURE_ITEM_ID	NUMBER	(15)	Yes	Expenditure item unique identifier
EXPENDITURE_TYPE	VARCHAR2	(30)	Yes	Expenditure type associated with this expenditure
EXPENDITURE_CATEGORY	VARCHAR2	(30)	Yes	Expenditure category associated with this expenditure
REVENUE_CATEGORY_CODE	VARCHAR2	(30)	Yes	Revenue category of the expenditure
EXPENDITURE_ORG	VARCHAR2	(240)	Yes	Organization incurring the expenditure
ITEM_DATE	DATE		Yes	Date on which expenditure is incurred
QUANTITY	NUMBER			Quantity corresponding to this expenditure
UOM	VARCHAR2	(80)	Yes	Unit of measure
PROJFUNC_CURRENCY_CODE	VARCHAR2	(15)		Project functional currency code
BURDENED_COST	VARCHAR2	(4000)		Burdened cost
ACCRUED_REVENUE	VARCHAR2	(4000)		Total amount of revenue that the item accrued
BILL_AMOUNT	VARCHAR2	(4000)		Amount to be billed for the item
PROJECT_CURRENCY_CODE	VARCHAR2	(15)		Project Currency Code of the Transaction
PROJECT_BURDENED_COST	VARCHAR2	(4000)		Burdened cost in project currency
PROJECT_RAW_REVENUE	VARCHAR2	(4000)		Revenue Amount in Project
PROJECT_BILL_AMOUNT	VARCHAR2	(4000)		Bill Amount in Project
BILL_TRANS_CURRENCY_CODE	VARCHAR2	(15)		Bill transaction currency code for the expenditure item for accrued revenue and bill amounts
BILL_TRANS_BILL_AMOUNT	VARCHAR2	(4000)		Bill amount in bill transaction currency
NON_LABOR_RESC	VARCHAR2	(20)		Non-labor resource utilized as the work was performed
NON_LABOR_ORG	VARCHAR2	(240)		Organization that supplies the non-labor resource
INCURRED_BY_PERSON_ID	NUMBER	(15)		Unique identifier of employee incurring the expenditure
EMPLOYEE_NAME	VARCHAR2	(240)		Name of employee incurring the expenditure
EMPLOYEE_NUMBER	VARCHAR2	(30)		Employee Number of person incurring the expenditure
JOB_ID	NUMBER	(15)		Unique identifier of the job to which the employee is assigned as of the expenditure item date
JOB_NAME	VARCHAR2	(700)		Name of the job to which the employee is assigned as ofthe expenditure item date
SUPPLIER_ID	NUMBER			Supplier unique identifier
SUPPLIER_NAME	VARCHAR2	(240)		Supplier name

Query Text

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


SELECT PROJECT_ID
,      TASK_ID
,      TASK_NUMBER
,      EXPENDITURE_ITEM_ID
,      EXPENDITURE_TYPE
,      EXPENDITURE_CATEGORY
,      REVENUE_CATEGORY_CODE
,      EXPENDITURE_ORG
,      ITEM_DATE
,      QUANTITY
,      UOM
,      PROJFUNC_CURRENCY_CODE
,      BURDENED_COST
,      ACCRUED_REVENUE
,      BILL_AMOUNT
,      PROJECT_CURRENCY_CODE
,      PROJECT_BURDENED_COST
,      PROJECT_RAW_REVENUE
,      PROJECT_BILL_AMOUNT
,      BILL_TRANS_CURRENCY_CODE
,      BILL_TRANS_BILL_AMOUNT
,      NON_LABOR_RESC
,      NON_LABOR_ORG
,      INCURRED_BY_PERSON_ID
,      EMPLOYEE_NAME
,      EMPLOYEE_NUMBER
,      JOB_ID
,      JOB_NAME
,      SUPPLIER_ID
,      SUPPLIER_NAME
FROM APPS.PJM_PROJECT_EXPEND_V;

Dependencies

[top of page]

APPS.PJM_PROJECT_EXPEND_V references the following:

APPS: FND_CURRENCY_CACHE - show dependent code; HR_ALL_ORGANIZATION_UNITS_TL; PA_EXPENDITURES_ALL; PA_EXPENDITURE_INQUIRY - show dependent code; PA_EXPENDITURE_ITEMS_ALL; PA_EXPENDITURE_TYPES; PA_IMPLEMENTATIONS_ALL; PA_LOOKUPS; PA_TASKS; PER_ALL_PEOPLE_F; PER_JOBS; PO_VENDORS

APPS.PJM_PROJECT_EXPEND_V is not referenced by any database object