DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.PER_CONT_WORKERS_CURRENT_X

Object Details
Object Name: PER_CONT_WORKERS_CURRENT_X
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPER.PER_CONT_WORKERS_CURRENT_X
Subobject Name:
Status: VALID

View Type

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


The list of current contingent workers visible within the current security


[View Source]

Columns
Name Datatype Length Mandatory Comments
BUSINESS_GROUP_ID NUMBER (15) Yes Business Group Id.
ORGANIZATION_ID NUMBER (15) Yes Organization Id.
PERSON_ID NUMBER (10) Yes System generated person primary key from PER_PEOPLE_S.
ASSIGNMENT_ID NUMBER (10) Yes 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 non-payrolled worker
CURRENT_NPW_FLAG VARCHAR2 (30)
Flag for non payrolled worker
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)
VENDOR_SITE_ID
PO_HEADER_ID NUMBER (15)
PO_HEADER_ID
PO_LINE_ID NUMBER (15)
PO_LINE_ID
FULL_NAME VARCHAR2 (240)
Full Name.
FIRST_NAME VARCHAR2 (150)
First Name.
MIDDLE_NAME VARCHAR2 (60)
Middle Name.
LAST_NAME VARCHAR2 (150) Yes 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)
Expense Check Address Flag
ASSIGNMENT_TYPE VARCHAR2 (1) Yes Assignment type
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)
Stores personal name according to the defined Global List Name format
LOCAL_NAME VARCHAR2 (240)
Stores personal name according to the defined Local List Name format
LIST_NAME VARCHAR2 (4000)
Either a global or local name depending on the profile option HR_LOCAL_OR_GLOBAL_NAME_FORMAT
Query Text

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


SELECT 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_CONT_WORKERS_CURRENT_X;

Dependencies

[top of page]

APPS.PER_CONT_WORKERS_CURRENT_X references the following:

SchemaAPPS
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_PERSON_NAME - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
SynonymPER_ALL_ASSIGNMENTS_F
ViewPER_PEOPLE_F
SynonymPER_PERIODS_OF_PLACEMENT
APPS.PER_CONT_WORKERS_CURRENT_X is referenced by following:

SchemaAPPS
Package BodyAP_CARD_UTILITY_PKG - show dependent code
ViewAP_EXPENSE_REPORT_HEADERS_V
Package BodyAP_WEB_AMOUNT_UTIL - show dependent code
Package BodyAP_WEB_AUDIT_UTILS - show dependent code
Package BodyAP_WEB_DB_AP_INT_PKG - show dependent code
Package BodyAP_WEB_DB_CCARD_PKG - show dependent code
Package BodyAP_WEB_DB_EXPRPT_PKG - show dependent code
Package BodyAP_WEB_DB_HR_INT_PKG - show dependent code
Package BodyAP_WEB_DB_SCHLINE_PKG - show dependent code
Package BodyAP_WEB_EXPORT_ER - show dependent code
Package BodyAP_WEB_RECEIPTS_WF - show dependent code
ViewAP_WEB_SIGNING_LIMITS_V
Package BodyAP_WEB_UPLOAD_ACCUM_MILES_PKG - show dependent code
Package BodyPO_APPROVALLIST_S1 - show dependent code