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_ADJUSTMENTS_VIEW

Object Details

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

View Type

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

PA_PROJ_ADJUSTMENTS_VIEW is a view of the expenditure item adjustments for a project. This information includes details of the adjusted expenditure item, the date and action of the adjustment, and the person who performed the adjustment.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PROJECT_ID	NUMBER	(15)	Yes	Identifier of the project to which the adjusted expenditure item is charged
PROJECT_NUM	VARCHAR2	(25)	Yes	Number of the project incurring the adjusted expenditure item
PROJECT_NAME	VARCHAR2	(30)	Yes	Name of the project incurring the adjusted expenditure item
EXPENDITURE_ITEM_ID	NUMBER	(15)	Yes	Identifier of the expenditure item for which the adjustment was made
INCURRED_BY_EMPLOYEE_NAME	VARCHAR2	(240)		Name of the employee incurring the adjusted expenditure item
INCURRED_BY_EMPLOYEE_NUM	VARCHAR2	(30)		Numbe of the employee incurring the adjusted expenditure item
INCURRED_BY_PERSON_ID	NUMBER	(15)		Identifier of the employee who incurred the charges. This column is always populated for labor and expense charges and is not populated for vendor invoices. For usage charges, this column has a value if an employee was specified
VENDOR_ID	NUMBER			Identifier of the vendor for a vendor invoice item
VENDOR_NUM	VARCHAR2	(30)		Number of the vendor
VENDOR_NAME	VARCHAR2	(240)		Name of the vendor
EMPLOYEE_VENDOR_NAME	VARCHAR2	(240)		Name of an employee or vendor. This value is the vendor for vendor invoices, and the employee name for labor, expense report, and usage items
EMPLOYEE_VENDOR_NUM	VARCHAR2	(30)		Number of an employee or vendor. This value is the vendor number of vendor 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	(4000)		Name of the organization incurring the expenditure item
EXPENDITURE_TYPE	VARCHAR2	(30)	Yes	Expenditure type of the expenditure item
TASK_ID	NUMBER	(15)	Yes	Identifier of the task incurring the adjusted expenditure item
TASK_NUMBER	VARCHAR2	(25)	Yes	Number of the task incurring the adjusted expenditure item
TASK_NAME	VARCHAR2	(20)	Yes	Name of the task incurring the adjusted expenditure item
EXPENDITURE_ITEM_DATE	DATE		Yes	Expenditure item date
NON_LABOR_RESOURCE	VARCHAR2	(20)		Non-labor resource utilized as work was performed. This column is only populated for usage items
ADJUSTMENT_DATE	VARCHAR2	(18)		Date on which the expenditure item was adjusted. This column also reports the time of day that the adjustment was made
ADJUSTMENT_ACTIVITY	VARCHAR2	(30)	Yes	Type of adjustment performed on an expenditure item
ADJUSTED_BY_USER	VARCHAR2	(100)	Yes	User name of the person who made the adjustment
ADJUSTED_BY_USER_ID	NUMBER	(15)	Yes	Identifier of the user name of the person who made the adjustment
ADJUSTED_BY_PERSON_ID	NUMBER	(10)	Yes	Identifier of the employee who performed the adjustment
ADJUSTED_BY_NAME	VARCHAR2	(240)		Full name of the employee who performed the adjustment

Query Text

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


SELECT PROJECT_ID
,      PROJECT_NUM
,      PROJECT_NAME
,      EXPENDITURE_ITEM_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
,      EXPENDITURE_TYPE
,      TASK_ID
,      TASK_NUMBER
,      TASK_NAME
,      EXPENDITURE_ITEM_DATE
,      NON_LABOR_RESOURCE
,      ADJUSTMENT_DATE
,      ADJUSTMENT_ACTIVITY
,      ADJUSTED_BY_USER
,      ADJUSTED_BY_USER_ID
,      ADJUSTED_BY_PERSON_ID
,      ADJUSTED_BY_NAME
FROM APPS.PA_PROJ_ADJUSTMENTS_VIEW;

Dependencies

[top of page]

APPS.PA_PROJ_ADJUSTMENTS_VIEW references the following:

APPS: FND_USER; HR_GENERAL - show dependent code; HR_PERSON_NAME - show dependent code; HR_SECURITY - show dependent code; PA_EXPENDITURES_UTILS - show dependent code; PA_EXPEND_ITEM_ADJ_ACTIVITIES; PA_PROJ_EXPEND_VIEW; PA_UTILS4 - show dependent code; PER_PEOPLE_F

APPS.PA_PROJ_ADJUSTMENTS_VIEW is not referenced by any database object