[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PER_EXPANDED_ASSIGNMENTS_V1 |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  PER.PER_EXPANDED_ASSIGNMENTS_V1
|
| Subobject Name: | |
| Status: | VALID |
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.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PERSON_ID | NUMBER | (10) | Yes | |
| BUSINESS_GROUP_ID | NUMBER | |||
| FULL_NAME | VARCHAR2 | (240) | ||
| EMPLOYEE_NUMBER | VARCHAR2 | (30) | ||
| APPLICANT_NUMBER | VARCHAR2 | (30) | ||
| CURRENT_EMPLOYEE_FLAG | VARCHAR2 | (30) | ||
| CURRENT_APPLICANT_FLAG | VARCHAR2 | (30) | ||
| ASSIGNMENT_ID | NUMBER | (10) | Yes | |
| ASSIGNMENT_NUMBER | VARCHAR2 | (30) | ||
| ASSIGNMENT_TYPE | VARCHAR2 | (1) | Yes | |
| ORGANIZATION_ID | NUMBER | (15) | Yes | |
| PAYROLL_ID | NUMBER | (9) | ||
| PRIMARY_FLAG | VARCHAR2 | (30) | Yes | |
| GRADE_NAME | VARCHAR2 | (240) | ||
| JOB_NAME | VARCHAR2 | (700) | ||
| POSITION_NAME | VARCHAR2 | (4000) | ||
| ORG_NAME | VARCHAR2 | (240) | ||
| PAYROLLS_NAME | VARCHAR2 | (4000) | ||
| P_TYPE | VARCHAR2 | (4000) | ||
| MANAGER_FLAG | VARCHAR2 | (30) | ||
| LOCATION_CODE | VARCHAR2 | (4000) | ||
| SUP_NAME | VARCHAR2 | (240) | ||
| USER_STAT | VARCHAR2 | (80) | ||
| ASSIGNMENT_STATUS_TYPE_ID | NUMBER | (9) | Yes | |
| GRP_SEGMENT1 | VARCHAR2 | (60) | ||
| GRP_SEGMENT2 | VARCHAR2 | (60) | ||
| GRP_SEGMENT3 | VARCHAR2 | (60) | ||
| GRP_SEGMENT4 | VARCHAR2 | (60) | ||
| GRP_SEGMENT5 | VARCHAR2 | (60) | ||
| GRP_SEGMENT6 | VARCHAR2 | (60) | ||
| GRP_SEGMENT7 | VARCHAR2 | (60) | ||
| GRP_SEGMENT8 | VARCHAR2 | (60) | ||
| GRP_SEGMENT9 | VARCHAR2 | (60) | ||
| GRP_SEGMENT10 | VARCHAR2 | (60) | ||
| GRP_SEGMENT11 | VARCHAR2 | (60) | ||
| GRP_SEGMENT12 | VARCHAR2 | (60) | ||
| GRP_SEGMENT13 | VARCHAR2 | (60) | ||
| GRP_SEGMENT14 | VARCHAR2 | (60) | ||
| GRP_SEGMENT15 | VARCHAR2 | (60) | ||
| GRP_SEGMENT16 | VARCHAR2 | (60) | ||
| GRP_SEGMENT17 | VARCHAR2 | (60) | ||
| GRP_SEGMENT18 | VARCHAR2 | (60) | ||
| GRP_SEGMENT19 | VARCHAR2 | (60) | ||
| GRP_SEGMENT20 | VARCHAR2 | (60) | ||
| GRP_SEGMENT21 | VARCHAR2 | (60) | ||
| GRP_SEGMENT22 | VARCHAR2 | (60) | ||
| GRP_SEGMENT23 | VARCHAR2 | (60) | ||
| GRP_SEGMENT24 | VARCHAR2 | (60) | ||
| GRP_SEGMENT25 | VARCHAR2 | (60) | ||
| GRP_SEGMENT26 | VARCHAR2 | (60) | ||
| GRP_SEGMENT27 | VARCHAR2 | (60) | ||
| GRP_SEGMENT28 | VARCHAR2 | (60) | ||
| GRP_SEGMENT29 | VARCHAR2 | (60) | ||
| GRP_SEGMENT30 | VARCHAR2 | (60) | ||
| GRD_SEGMENT1 | VARCHAR2 | (60) | ||
| GRD_SEGMENT2 | VARCHAR2 | (60) | ||
| GRD_SEGMENT3 | VARCHAR2 | (60) | ||
| GRD_SEGMENT4 | VARCHAR2 | (60) | ||
| GRD_SEGMENT5 | VARCHAR2 | (60) | ||
| GRD_SEGMENT6 | VARCHAR2 | (60) | ||
| GRD_SEGMENT7 | VARCHAR2 | (60) | ||
| GRD_SEGMENT8 | VARCHAR2 | (60) | ||
| GRD_SEGMENT9 | VARCHAR2 | (60) | ||
| GRD_SEGMENT10 | VARCHAR2 | (60) | ||
| GRD_SEGMENT11 | VARCHAR2 | (60) | ||
| GRD_SEGMENT12 | VARCHAR2 | (60) | ||
| GRD_SEGMENT13 | VARCHAR2 | (60) | ||
| GRD_SEGMENT14 | VARCHAR2 | (60) | ||
| GRD_SEGMENT15 | VARCHAR2 | (60) | ||
| GRD_SEGMENT16 | VARCHAR2 | (60) | ||
| GRD_SEGMENT17 | VARCHAR2 | (60) | ||
| GRD_SEGMENT18 | VARCHAR2 | (60) | ||
| GRD_SEGMENT19 | VARCHAR2 | (60) | ||
| GRD_SEGMENT20 | VARCHAR2 | (60) | ||
| GRD_SEGMENT21 | VARCHAR2 | (60) | ||
| GRD_SEGMENT22 | VARCHAR2 | (60) | ||
| GRD_SEGMENT23 | VARCHAR2 | (60) | ||
| GRD_SEGMENT24 | VARCHAR2 | (60) | ||
| GRD_SEGMENT25 | VARCHAR2 | (60) | ||
| GRD_SEGMENT26 | VARCHAR2 | (60) | ||
| GRD_SEGMENT27 | VARCHAR2 | (60) | ||
| GRD_SEGMENT28 | VARCHAR2 | (60) | ||
| GRD_SEGMENT29 | VARCHAR2 | (60) | ||
| GRD_SEGMENT30 | VARCHAR2 | (60) | ||
| JOB_SEGMENT1 | VARCHAR2 | (60) | ||
| JOB_SEGMENT2 | VARCHAR2 | (60) | ||
| JOB_SEGMENT3 | VARCHAR2 | (60) | ||
| JOB_SEGMENT4 | VARCHAR2 | (60) | ||
| JOB_SEGMENT5 | VARCHAR2 | (60) | ||
| JOB_SEGMENT6 | VARCHAR2 | (60) | ||
| JOB_SEGMENT7 | VARCHAR2 | (60) | ||
| JOB_SEGMENT8 | VARCHAR2 | (60) | ||
| JOB_SEGMENT9 | VARCHAR2 | (60) | ||
| JOB_SEGMENT10 | VARCHAR2 | (60) | ||
| JOB_SEGMENT11 | VARCHAR2 | (60) | ||
| JOB_SEGMENT12 | VARCHAR2 | (60) | ||
| JOB_SEGMENT13 | VARCHAR2 | (60) | ||
| JOB_SEGMENT14 | VARCHAR2 | (60) | ||
| JOB_SEGMENT15 | VARCHAR2 | (60) | ||
| JOB_SEGMENT16 | VARCHAR2 | (60) | ||
| JOB_SEGMENT17 | VARCHAR2 | (60) | ||
| JOB_SEGMENT18 | VARCHAR2 | (60) | ||
| JOB_SEGMENT19 | VARCHAR2 | (60) | ||
| JOB_SEGMENT20 | VARCHAR2 | (60) | ||
| JOB_SEGMENT21 | VARCHAR2 | (60) | ||
| JOB_SEGMENT22 | VARCHAR2 | (60) | ||
| JOB_SEGMENT23 | VARCHAR2 | (60) | ||
| JOB_SEGMENT24 | VARCHAR2 | (60) | ||
| JOB_SEGMENT25 | VARCHAR2 | (60) | ||
| JOB_SEGMENT26 | VARCHAR2 | (60) | ||
| JOB_SEGMENT27 | VARCHAR2 | (60) | ||
| JOB_SEGMENT28 | VARCHAR2 | (60) | ||
| JOB_SEGMENT29 | VARCHAR2 | (60) | ||
| JOB_SEGMENT30 | VARCHAR2 | (60) | ||
| POS_SEGMENT1 | VARCHAR2 | (60) | ||
| POS_SEGMENT2 | VARCHAR2 | (60) | ||
| POS_SEGMENT3 | VARCHAR2 | (60) | ||
| POS_SEGMENT4 | VARCHAR2 | (60) | ||
| POS_SEGMENT5 | VARCHAR2 | (60) | ||
| POS_SEGMENT6 | VARCHAR2 | (60) | ||
| POS_SEGMENT7 | VARCHAR2 | (60) | ||
| POS_SEGMENT8 | VARCHAR2 | (60) | ||
| POS_SEGMENT9 | VARCHAR2 | (60) | ||
| POS_SEGMENT10 | VARCHAR2 | (60) | ||
| POS_SEGMENT11 | VARCHAR2 | (60) | ||
| POS_SEGMENT12 | VARCHAR2 | (60) | ||
| POS_SEGMENT13 | VARCHAR2 | (60) | ||
| POS_SEGMENT14 | VARCHAR2 | (60) | ||
| POS_SEGMENT15 | VARCHAR2 | (60) | ||
| POS_SEGMENT16 | VARCHAR2 | (60) | ||
| POS_SEGMENT17 | VARCHAR2 | (60) | ||
| POS_SEGMENT18 | VARCHAR2 | (60) | ||
| POS_SEGMENT19 | VARCHAR2 | (60) | ||
| POS_SEGMENT20 | VARCHAR2 | (60) | ||
| POS_SEGMENT21 | VARCHAR2 | (60) | ||
| POS_SEGMENT22 | VARCHAR2 | (60) | ||
| POS_SEGMENT23 | VARCHAR2 | (60) | ||
| POS_SEGMENT24 | VARCHAR2 | (60) | ||
| POS_SEGMENT25 | VARCHAR2 | (60) | ||
| POS_SEGMENT26 | VARCHAR2 | (60) | ||
| POS_SEGMENT27 | VARCHAR2 | (60) | ||
| POS_SEGMENT28 | VARCHAR2 | (60) | ||
| POS_SEGMENT29 | VARCHAR2 | (60) | ||
| POS_SEGMENT30 | VARCHAR2 | (60) | ||
| SALARY | VARCHAR2 | (4000) | ||
| PAY_BASIS | VARCHAR2 | (4000) | ||
| LAST_UPDATE_DATE | DATE | |||
| LAST_UPDATED_BY | NUMBER | (15) | ||
| LAST_UPDATE_LOGIN | NUMBER | (15) | ||
| CREATED_BY | NUMBER | (15) | ||
| CREATION_DATE | DATE | |||
| NPW_NUMBER | VARCHAR2 | (30) | Non-payrolled worker number | |
| CURRENT_NPW_FLAG | VARCHAR2 | (30) | Indicates non-payrolled worker status |
Cut, paste (and edit) the following text to query this object:
SELECT PERSON_ID
, BUSINESS_GROUP_ID
, FULL_NAME
, EMPLOYEE_NUMBER
, APPLICANT_NUMBER
, CURRENT_EMPLOYEE_FLAG
, CURRENT_APPLICANT_FLAG
, ASSIGNMENT_ID
, ASSIGNMENT_NUMBER
, ASSIGNMENT_TYPE
, ORGANIZATION_ID
, PAYROLL_ID
, PRIMARY_FLAG
, GRADE_NAME
, JOB_NAME
, POSITION_NAME
, ORG_NAME
, PAYROLLS_NAME
, P_TYPE
, MANAGER_FLAG
, LOCATION_CODE
, SUP_NAME
, USER_STAT
, ASSIGNMENT_STATUS_TYPE_ID
, GRP_SEGMENT1
, GRP_SEGMENT2
, GRP_SEGMENT3
, GRP_SEGMENT4
, GRP_SEGMENT5
, GRP_SEGMENT6
, GRP_SEGMENT7
, GRP_SEGMENT8
, GRP_SEGMENT9
, GRP_SEGMENT10
, GRP_SEGMENT11
, GRP_SEGMENT12
, GRP_SEGMENT13
, GRP_SEGMENT14
, GRP_SEGMENT15
, GRP_SEGMENT16
, GRP_SEGMENT17
, GRP_SEGMENT18
, GRP_SEGMENT19
, GRP_SEGMENT20
, GRP_SEGMENT21
, GRP_SEGMENT22
, GRP_SEGMENT23
, GRP_SEGMENT24
, GRP_SEGMENT25
, GRP_SEGMENT26
, GRP_SEGMENT27
, GRP_SEGMENT28
, GRP_SEGMENT29
, GRP_SEGMENT30
, GRD_SEGMENT1
, GRD_SEGMENT2
, GRD_SEGMENT3
, GRD_SEGMENT4
, GRD_SEGMENT5
, GRD_SEGMENT6
, GRD_SEGMENT7
, GRD_SEGMENT8
, GRD_SEGMENT9
, GRD_SEGMENT10
, GRD_SEGMENT11
, GRD_SEGMENT12
, GRD_SEGMENT13
, GRD_SEGMENT14
, GRD_SEGMENT15
, GRD_SEGMENT16
, GRD_SEGMENT17
, GRD_SEGMENT18
, GRD_SEGMENT19
, GRD_SEGMENT20
, GRD_SEGMENT21
, GRD_SEGMENT22
, GRD_SEGMENT23
, GRD_SEGMENT24
, GRD_SEGMENT25
, GRD_SEGMENT26
, GRD_SEGMENT27
, GRD_SEGMENT28
, GRD_SEGMENT29
, GRD_SEGMENT30
, JOB_SEGMENT1
, JOB_SEGMENT2
, JOB_SEGMENT3
, JOB_SEGMENT4
, JOB_SEGMENT5
, JOB_SEGMENT6
, JOB_SEGMENT7
, JOB_SEGMENT8
, JOB_SEGMENT9
, JOB_SEGMENT10
, JOB_SEGMENT11
, JOB_SEGMENT12
, JOB_SEGMENT13
, JOB_SEGMENT14
, JOB_SEGMENT15
, JOB_SEGMENT16
, JOB_SEGMENT17
, JOB_SEGMENT18
, JOB_SEGMENT19
, JOB_SEGMENT20
, JOB_SEGMENT21
, JOB_SEGMENT22
, JOB_SEGMENT23
, JOB_SEGMENT24
, JOB_SEGMENT25
, JOB_SEGMENT26
, JOB_SEGMENT27
, JOB_SEGMENT28
, JOB_SEGMENT29
, JOB_SEGMENT30
, POS_SEGMENT1
, POS_SEGMENT2
, POS_SEGMENT3
, POS_SEGMENT4
, POS_SEGMENT5
, POS_SEGMENT6
, POS_SEGMENT7
, POS_SEGMENT8
, POS_SEGMENT9
, POS_SEGMENT10
, POS_SEGMENT11
, POS_SEGMENT12
, POS_SEGMENT13
, POS_SEGMENT14
, POS_SEGMENT15
, POS_SEGMENT16
, POS_SEGMENT17
, POS_SEGMENT18
, POS_SEGMENT19
, POS_SEGMENT20
, POS_SEGMENT21
, POS_SEGMENT22
, POS_SEGMENT23
, POS_SEGMENT24
, POS_SEGMENT25
, POS_SEGMENT26
, POS_SEGMENT27
, POS_SEGMENT28
, POS_SEGMENT29
, POS_SEGMENT30
, SALARY
, PAY_BASIS
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, NPW_NUMBER
, CURRENT_NPW_FLAG
FROM APPS.PER_EXPANDED_ASSIGNMENTS_V1;
APPS
FND_SESSIONS
HR_ALL_ORGANIZATION_UNITS
HR_ALL_ORGANIZATION_UNITS_TL
HR_GENERAL
- show dependent code
HR_PERSON_NAME
- show dependent code
HR_PERSON_TYPE_USAGE_INFO
- show dependent code
HR_SECURITY
- show dependent code
PAY_PEOPLE_GROUPS
PER_ALL_ASSIGNMENTS_F
PER_ALL_PEOPLE_F
PER_ASSIGNMENT_STATUS_TYPES
PER_ASSIGNMENT_STATUS_TYPES_TL
PER_ASS_STATUS_TYPE_AMENDS
PER_ASS_STATUS_TYPE_AMENDS_TL
PER_GRADES
PER_GRADES_TL
PER_GRADE_DEFINITIONS
PER_JOBS
PER_JOBS_TL
PER_JOB_DEFINITIONS
PER_PEOPLE_F
PER_PERSON_TYPES
PER_PERSON_TYPES_TL
PER_POSITION_DEFINITIONS
APPS.PER_EXPANDED_ASSIGNMENTS_V1 is not referenced by any database object
|
|
|
|