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_LABOR_EXPENDITURES_VIEW

Object Details

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

View Type

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

PA_LABOR_EXPENDITURES_VIEW shows detail labor transactions for employee activity and utilization.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PROJECT_ID	NUMBER	(15)	Yes	The identifier of the project to which the expenditure item is charged
PROJECT_NUMBER	VARCHAR2	(25)	Yes	The number of the project
PROJECT_NAME	VARCHAR2	(30)	Yes	The name of the project
PROJECT_TYPE	VARCHAR2	(20)	Yes	The project type of the project
TASK_ID	NUMBER	(15)	Yes	The identifier of the task to which the expenditure item is charged
TASK_NUMBER	VARCHAR2	(25)	Yes	The number of the task
TASK_NAME	VARCHAR2	(20)	Yes	The name of the task
INCURRED_BY_PERSON_ID	NUMBER	(10)	Yes	The identifier of the employee who incurred the expenditure item
INCURRED_BY_EMPLOYEE_NUM	VARCHAR2	(30)		The number of the employee
INCURRED_BY_NAME	VARCHAR2	(240)		The full name of the employee
JOB_ID	NUMBER	(15)		The identifier of the job to which the employee is assigned as of the expenditure item date
JOB_NAME	VARCHAR2	(700)		The name of the job to which the employee is assigned as of the expenditure item date
ASSIGNED_TO_ORGANIZATION_ID	NUMBER	(15)	Yes	The identifier of the organization to which the employee is assigned as of the expenditure item date
ASSIGNED_TO_ORGANIZATION_NAME	VARCHAR2	(240)	Yes	The name of the organization to which the employee is assigned as of the expenditure item date
EXPENDITURE_ENDING_DATE	DATE		Yes	The expenditure ending date in which the expenditure item date falls
ORIG_USER_EXP_TXN_REFERENCE	VARCHAR2	(60)		Original user expenditure transaction reference
EXPENDITURE_ITEM_DATE	DATE		Yes	The date of the expenditure item
EXPENDITURE_TYPE	VARCHAR2	(30)	Yes	The expenditure type of the expenditure item
TOTAL_HOURS	NUMBER			Total straight time hours. If the expenditure type of the item is classified with a system linkage of ALLOCATED_OVERTIME, the total hours is displayed as 0 for that item
PREMIUM_HOURS	NUMBER			Premium hours. If the expenditure type of the item is classified with a system linkage of ALLOCATED_OVERTIME, the hours are reported in this column
BILLABLE_HOURS	NUMBER			Billable straight time hours
NON_BILLABLE_HOURS	NUMBER			Non-billable straight time hours
RAW_COST	NUMBER			Raw cost
BURDEN_COST	NUMBER			Burden cost
POTENTIAL_REVENUE	NUMBER			Potential revenue
ACCRUED_REVENUE	NUMBER	(22)		Accrued revenue
BILLABLE_FLAG	VARCHAR2	(1)	Yes	Billable flag of the expenditure item
DENOM_CURRENCY_CODE	VARCHAR2	(15)		Transaction currency code
DENOM_RAW_COST	NUMBER			Raw cost in transaction currency
DENOM_BURDENED_COST	NUMBER			Burdened cost in transaction currency
ACCT_CURRENCY_CODE	VARCHAR2	(15)		Functional currency code
ACCT_RATE_DATE	DATE			Conversion date used to convert raw cost from transaction currency to functional currency
ACCT_RATE_TYPE	VARCHAR2	(30)		Conversion type used to convert raw cost from transaction currency to functional currency
ACCT_EXCHANGE_RATE	NUMBER			Conversion rate used to convert raw cost from transaction currency to functional currency.
ACCT_RAW_COST	NUMBER			Raw cost in functional currency
ACCT_BURDENED_COST	NUMBER			Burdened cost in functional currency
PROJECT_CURRENCY_CODE	VARCHAR2	(15)		Project currency code.
PROJECT_RATE_DATE	DATE			Conversion date used to convert raw cost from transaction currency to project currency.
PROJECT_RATE_TYPE	VARCHAR2	(30)		Conversion date used to convert raw cost from transaction currency to project currency.
PROJECT_EXCHANGE_RATE	NUMBER			Conversion rate used to convert raw cost from transaction currency to project currency.
TRANSFER_STATUS_CODE	VARCHAR2	(1)		Indicates the status of the timecard transferred from Self Service Time to Oracle Projects.
WF_STATUS_CODE	VARCHAR2	(30)		Indicates the status of the workflow associated with the timecard approval
ORIG_EXP_TXN_REFERENCE1	VARCHAR2	(60)		Original expenditure transaction reference1
ORIG_EXP_TXN_REFERENCE2	VARCHAR2	(60)		Original expenditure transaction reference2
ORIG_EXP_TXN_REFERENCE3	VARCHAR2	(60)		Original expenditure transaction reference3
USER_BATCH_NAME	VARCHAR2	(50)		Batch name for timecards entered through Self Service Time, used to group timecards into batches through Transaction Import
OVERRIDING_APPROVER_PERSON_ID	NUMBER			Overriding approver for the timecard

Query Text

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


SELECT PROJECT_ID
,      PROJECT_NUMBER
,      PROJECT_NAME
,      PROJECT_TYPE
,      TASK_ID
,      TASK_NUMBER
,      TASK_NAME
,      INCURRED_BY_PERSON_ID
,      INCURRED_BY_EMPLOYEE_NUM
,      INCURRED_BY_NAME
,      JOB_ID
,      JOB_NAME
,      ASSIGNED_TO_ORGANIZATION_ID
,      ASSIGNED_TO_ORGANIZATION_NAME
,      EXPENDITURE_ENDING_DATE
,      ORIG_USER_EXP_TXN_REFERENCE
,      EXPENDITURE_ITEM_DATE
,      EXPENDITURE_TYPE
,      TOTAL_HOURS
,      PREMIUM_HOURS
,      BILLABLE_HOURS
,      NON_BILLABLE_HOURS
,      RAW_COST
,      BURDEN_COST
,      POTENTIAL_REVENUE
,      ACCRUED_REVENUE
,      BILLABLE_FLAG
,      DENOM_CURRENCY_CODE
,      DENOM_RAW_COST
,      DENOM_BURDENED_COST
,      ACCT_CURRENCY_CODE
,      ACCT_RATE_DATE
,      ACCT_RATE_TYPE
,      ACCT_EXCHANGE_RATE
,      ACCT_RAW_COST
,      ACCT_BURDENED_COST
,      PROJECT_CURRENCY_CODE
,      PROJECT_RATE_DATE
,      PROJECT_RATE_TYPE
,      PROJECT_EXCHANGE_RATE
,      TRANSFER_STATUS_CODE
,      WF_STATUS_CODE
,      ORIG_EXP_TXN_REFERENCE1
,      ORIG_EXP_TXN_REFERENCE2
,      ORIG_EXP_TXN_REFERENCE3
,      USER_BATCH_NAME
,      OVERRIDING_APPROVER_PERSON_ID
FROM APPS.PA_LABOR_EXPENDITURES_VIEW;

Dependencies

[top of page]

APPS.PA_LABOR_EXPENDITURES_VIEW references the following:

APPS: HR_GENERAL - show dependent code; HR_ORGANIZATION_UNITS; HR_PERSON_NAME - show dependent code; HR_SECURITY - show dependent code; PA_EXPENDITURES_ALL; PA_EXPENDITURE_ITEMS_ALL; PA_PROJECTS_ALL; PA_TASKS; PER_JOBS; PER_PEOPLE_F

APPS.PA_LABOR_EXPENDITURES_VIEW is not referenced by any database object