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

Object Details

Object Name:	PER_WORKFORCE_CURRENT_X
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PER.PER_WORKFORCE_CURRENT_X
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Comments
EMPLOYEE_NUMBER	VARCHAR2	(30)	employee number
CURRENT_EMPLOYEE_FLAG	VARCHAR2	(30)	Determines if person is current employee.
BUSINESS_GROUP_ID	NUMBER	(15)	Business Group Id.
ORGANIZATION_ID	NUMBER	(15)	Organization Id.
PERSON_ID	NUMBER	(10)	System generated person primary key from PER_PEOPLE_S.
ASSIGNMENT_ID	NUMBER	(10)	Assignment Id.
LAST_UPDATE_DATE	DATE		Standard who column.
LAST_UPDATED_BY	NUMBER	(15)	Standard who column.
LAST_UPDATE_LOGIN	NUMBER	(15)	Standard who column.
CREATION_DATE	DATE		Standard who column.
CREATED_BY	NUMBER	(15)	Standard who column.
NPW_NUMBER	VARCHAR2	(30)	Number for contingent worker
CURRENT_NPW_FLAG	VARCHAR2	(30)
VENDOR_ID	NUMBER	(15)	Foreign key reference to po_vendors
VENDOR_EMPLOYEE_NUMBER	VARCHAR2	(30)	Employee number of worker with vending organization
VENDOR_ASSIGNMENT_NUMBER	VARCHAR2	(30)	Assignment number of non-payrolled worker assignment with vending organization
VENDOR_SITE_ID	NUMBER	(15)
PO_HEADER_ID	NUMBER	(15)
PO_LINE_ID	NUMBER	(15)
FULL_NAME	VARCHAR2	(240)	Full Name.
FIRST_NAME	VARCHAR2	(150)	First Name.
MIDDLE_NAME	VARCHAR2	(60)	Middle Name.
LAST_NAME	VARCHAR2	(150)	Last Name
PREFIX	VARCHAR2	(30)	Prefix.
LOCATION_ID	NUMBER	(15)	Working Location Id.
SUPERVISOR_ID	NUMBER	(10)	Supervisor Id.
SUPERVISOR_ASSIGNMENT_ID	NUMBER	(15)	Supervisor Assignment Id.
SET_OF_BOOKS_ID	NUMBER	(15)	Set of Books Id.
DEFAULT_CODE_COMBINATION_ID	NUMBER	(15)	Identifies GL key flexfield structure.
TERMINATION_DATE	DATE		Actual date of termination of period of placement
PROJECT_TITLE	VARCHAR2	(30)	Title of project of which this assignment forms part
BILLING_TITLE	VARCHAR2	(30)	Title for assignment.
EMAIL_ADDRESS	VARCHAR2	(240)	Email Address.
EXPENSE_CHECK_ADDRESS_FLAG	VARCHAR2	(30)
ASSIGNMENT_TYPE	VARCHAR2	(1)
ATTRIBUTE1	VARCHAR2	(150)	Descriptive flexfield column.
ATTRIBUTE2	VARCHAR2	(150)	Descriptive flexfield column.
ATTRIBUTE3	VARCHAR2	(150)	Descriptive flexfield column.
ATTRIBUTE4	VARCHAR2	(150)	Descriptive flexfield column.
ATTRIBUTE5	VARCHAR2	(150)	Descriptive flexfield column.
ATTRIBUTE6	VARCHAR2	(150)	Descriptive flexfield column.
ATTRIBUTE7	VARCHAR2	(150)	Descriptive flexfield column.
ATTRIBUTE8	VARCHAR2	(150)	Descriptive flexfield column.
ATTRIBUTE9	VARCHAR2	(150)	Descriptive flexfield column.
ATTRIBUTE10	VARCHAR2	(150)	Descriptive flexfield column.
ATTRIBUTE11	VARCHAR2	(150)	Descriptive flexfield column.
ATTRIBUTE12	VARCHAR2	(150)	Descriptive flexfield column.
ATTRIBUTE13	VARCHAR2	(150)	Descriptive flexfield column.
ATTRIBUTE14	VARCHAR2	(150)	Descriptive flexfield column.
ATTRIBUTE15	VARCHAR2	(150)	Descriptive flexfield column.
ATTRIBUTE16	VARCHAR2	(150)	Descriptive flexfield column.
ATTRIBUTE17	VARCHAR2	(150)	Descriptive flexfield column.
ATTRIBUTE18	VARCHAR2	(150)	Descriptive flexfield column.
ATTRIBUTE19	VARCHAR2	(150)	Descriptive flexfield column.
ATTRIBUTE20	VARCHAR2	(150)	Descriptive flexfield column.
ATTRIBUTE21	VARCHAR2	(150)	Descriptive flexfield column.
ATTRIBUTE22	VARCHAR2	(150)	Descriptive flexfield column.
ATTRIBUTE23	VARCHAR2	(150)	Descriptive flexfield column.
ATTRIBUTE24	VARCHAR2	(150)	Descriptive flexfield column.
ATTRIBUTE25	VARCHAR2	(150)	Descriptive flexfield column.
ATTRIBUTE26	VARCHAR2	(150)	Descriptive flexfield column.
ATTRIBUTE27	VARCHAR2	(150)	Descriptive flexfield column.
ATTRIBUTE28	VARCHAR2	(150)	Descriptive flexfield column.
ATTRIBUTE29	VARCHAR2	(150)	Descriptive flexfield column.
ATTRIBUTE30	VARCHAR2	(150)	Descriptive flexfield column.
ATTRIBUTE_CATEGORY	VARCHAR2	(30)	Descriptive flexfield column.
PARTY_ID	NUMBER	(15)	foreign key to HZ_PARTIES
GLOBAL_NAME	VARCHAR2	(240)
LOCAL_NAME	VARCHAR2	(240)
LIST_NAME	VARCHAR2	(4000)

Query Text

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


SELECT EMPLOYEE_NUMBER
,      CURRENT_EMPLOYEE_FLAG
,      BUSINESS_GROUP_ID
,      ORGANIZATION_ID
,      PERSON_ID
,      ASSIGNMENT_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      NPW_NUMBER
,      CURRENT_NPW_FLAG
,      VENDOR_ID
,      VENDOR_EMPLOYEE_NUMBER
,      VENDOR_ASSIGNMENT_NUMBER
,      VENDOR_SITE_ID
,      PO_HEADER_ID
,      PO_LINE_ID
,      FULL_NAME
,      FIRST_NAME
,      MIDDLE_NAME
,      LAST_NAME
,      PREFIX
,      LOCATION_ID
,      SUPERVISOR_ID
,      SUPERVISOR_ASSIGNMENT_ID
,      SET_OF_BOOKS_ID
,      DEFAULT_CODE_COMBINATION_ID
,      TERMINATION_DATE
,      PROJECT_TITLE
,      BILLING_TITLE
,      EMAIL_ADDRESS
,      EXPENSE_CHECK_ADDRESS_FLAG
,      ASSIGNMENT_TYPE
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      ATTRIBUTE_CATEGORY
,      PARTY_ID
,      GLOBAL_NAME
,      LOCAL_NAME
,      LIST_NAME
FROM APPS.PER_WORKFORCE_CURRENT_X;

Dependencies

[top of page]

APPS.PER_WORKFORCE_CURRENT_X references the following:

APPS: HR_GENERAL - show dependent code; HR_PERSON_NAME - show dependent code; HR_SECURITY - show dependent code; PER_ALL_ASSIGNMENTS_F; PER_PEOPLE_F; PER_PERIODS_OF_PLACEMENT; PER_PERIODS_OF_SERVICE

APPS.PER_WORKFORCE_CURRENT_X is referenced by following:

APPS: AP_WEB_DB_HR_INT_PKG - show dependent code; AP_WEB_EXPENSE_FORM - show dependent code; CSC_CUSTOMERS_EMPLOYEES_V; CSC_PROFILE_ENGINE_PKG - show dependent code; FUN_CONTACTUS_EMAIL - show dependent code; IBU_DYN_USER_GROUPS_PKG - show dependent code; IEM_EMAIL_PROC_PVT - show dependent code; INV_PHY_INV_LOVS - show dependent code; JTF_IH_PUB - show dependent code; OE_PURCHASE_RELEASE_PVT - show dependent code; PON_NEGOTIATION_PUBLISH_PVT - show dependent code; PON_VALIDATE_ITEM_PRICES_INT - show dependent code; PON_VALIDATE_PAYMENTS_INT - show dependent code; PORCPTWF - show dependent code; POR_UTIL_PKG - show dependent code; POS_CLM_UTIL_PKG - show dependent code; PO_ALERT_BLANKET_VIEW; PO_COPYDOC_SUB - show dependent code; PO_DOCUMENT_ACTION_PVT - show dependent code; PO_DOCUMENT_ACTION_UTIL - show dependent code; PO_EMPLOYEES_SV - show dependent code; PO_PDOI_POSTPROC_PVT - show dependent code; PO_WF_PO_RULE_ACC - show dependent code; RCV_TRANSACTIONS_SV - show dependent code; RCV_TRANSACTION_SV - show dependent code