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


VIEW: APPS.PER_KR_ASSIGNMENTS_V

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

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
BUSINESS_GROUP_ID NUMBER (15) Yes
PERSON_ID NUMBER (10) Yes
PERIOD_OF_SERVICE_ID NUMBER (15)
ASSIGNMENT_NUMBER VARCHAR2 (30)
EFFECTIVE_START_DATE DATE
Yes
ORGANIZATION_ID NUMBER (15) Yes
JOB_ID NUMBER (15)
POSITION_ID NUMBER (15)
GRADE_ID NUMBER (15)
PEOPLE_GROUP_ID NUMBER (15)
PAYROLL_ID NUMBER (9)
ASSIGNMENT_ID NUMBER (10) Yes
LOCATION_ID NUMBER (15)
ASSIGNMENT_STATUS_TYPE_ID NUMBER (9) Yes
CHANGE_REASON VARCHAR2 (30)
ASSIGNMENT_SEQUENCE NUMBER (15) Yes
ASS_ATTRIBUTE_CATEGORY VARCHAR2 (30)
ASS_ATTRIBUTE1 VARCHAR2 (150)
ASS_ATTRIBUTE2 VARCHAR2 (150)
ASS_ATTRIBUTE3 VARCHAR2 (150)
ASS_ATTRIBUTE4 VARCHAR2 (150)
ASS_ATTRIBUTE5 VARCHAR2 (150)
ASS_ATTRIBUTE6 VARCHAR2 (150)
ASS_ATTRIBUTE7 VARCHAR2 (150)
ASS_ATTRIBUTE8 VARCHAR2 (150)
ASS_ATTRIBUTE9 VARCHAR2 (150)
ASS_ATTRIBUTE10 VARCHAR2 (150)
ASS_ATTRIBUTE11 VARCHAR2 (150)
ASS_ATTRIBUTE12 VARCHAR2 (150)
ASS_ATTRIBUTE13 VARCHAR2 (150)
ASS_ATTRIBUTE14 VARCHAR2 (150)
ASS_ATTRIBUTE15 VARCHAR2 (150)
ASS_ATTRIBUTE16 VARCHAR2 (150)
ASS_ATTRIBUTE17 VARCHAR2 (150)
ASS_ATTRIBUTE18 VARCHAR2 (150)
ASS_ATTRIBUTE19 VARCHAR2 (150)
ASS_ATTRIBUTE20 VARCHAR2 (150)
ASS_ATTRIBUTE21 VARCHAR2 (150)
ASS_ATTRIBUTE22 VARCHAR2 (150)
ASS_ATTRIBUTE23 VARCHAR2 (150)
ASS_ATTRIBUTE24 VARCHAR2 (150)
ASS_ATTRIBUTE25 VARCHAR2 (150)
ASS_ATTRIBUTE26 VARCHAR2 (150)
ASS_ATTRIBUTE27 VARCHAR2 (150)
ASS_ATTRIBUTE28 VARCHAR2 (150)
ASS_ATTRIBUTE29 VARCHAR2 (150)
ASS_ATTRIBUTE30 VARCHAR2 (150)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
CREATED_BY NUMBER (15)
CREATION_DATE DATE

ORGANIZATION VARCHAR2 (240) Yes
GRADE VARCHAR2 (240)
PAYROLL VARCHAR2 (80)
JOB VARCHAR2 (700)
POSITION VARCHAR2 (4000)
LOCATION_CODE VARCHAR2 (60)
EMPLOYMENT_CATEGORY VARCHAR2 (80)
SALARY_BASIS VARCHAR2 (30)
STATUS VARCHAR2 (80)
REASON VARCHAR2 (80)
SOFT_CODING_KEYFLEX_ID NUMBER (15)
KR_JOB_TITLE VARCHAR2 (80)
KR_SENIORITY VARCHAR2 (80)
KR_SECOND_GRADE VARCHAR2 (80)
KR_SECOND_POINT VARCHAR2 (80)
Query Text

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


SELECT ROW_ID
,      BUSINESS_GROUP_ID
,      PERSON_ID
,      PERIOD_OF_SERVICE_ID
,      ASSIGNMENT_NUMBER
,      EFFECTIVE_START_DATE
,      ORGANIZATION_ID
,      JOB_ID
,      POSITION_ID
,      GRADE_ID
,      PEOPLE_GROUP_ID
,      PAYROLL_ID
,      ASSIGNMENT_ID
,      LOCATION_ID
,      ASSIGNMENT_STATUS_TYPE_ID
,      CHANGE_REASON
,      ASSIGNMENT_SEQUENCE
,      ASS_ATTRIBUTE_CATEGORY
,      ASS_ATTRIBUTE1
,      ASS_ATTRIBUTE2
,      ASS_ATTRIBUTE3
,      ASS_ATTRIBUTE4
,      ASS_ATTRIBUTE5
,      ASS_ATTRIBUTE6
,      ASS_ATTRIBUTE7
,      ASS_ATTRIBUTE8
,      ASS_ATTRIBUTE9
,      ASS_ATTRIBUTE10
,      ASS_ATTRIBUTE11
,      ASS_ATTRIBUTE12
,      ASS_ATTRIBUTE13
,      ASS_ATTRIBUTE14
,      ASS_ATTRIBUTE15
,      ASS_ATTRIBUTE16
,      ASS_ATTRIBUTE17
,      ASS_ATTRIBUTE18
,      ASS_ATTRIBUTE19
,      ASS_ATTRIBUTE20
,      ASS_ATTRIBUTE21
,      ASS_ATTRIBUTE22
,      ASS_ATTRIBUTE23
,      ASS_ATTRIBUTE24
,      ASS_ATTRIBUTE25
,      ASS_ATTRIBUTE26
,      ASS_ATTRIBUTE27
,      ASS_ATTRIBUTE28
,      ASS_ATTRIBUTE29
,      ASS_ATTRIBUTE30
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      ORGANIZATION
,      GRADE
,      PAYROLL
,      JOB
,      POSITION
,      LOCATION_CODE
,      EMPLOYMENT_CATEGORY
,      SALARY_BASIS
,      STATUS
,      REASON
,      SOFT_CODING_KEYFLEX_ID
,      KR_JOB_TITLE
,      KR_SENIORITY
,      KR_SECOND_GRADE
,      KR_SECOND_POINT
FROM APPS.PER_KR_ASSIGNMENTS_V;

Dependencies

[top of page]

APPS.PER_KR_ASSIGNMENTS_V references the following:

SchemaAPPS
SynonymHR_ALL_ORGANIZATION_UNITS_TL
PL/SQL PackageHR_API - show dependent code
PL/SQL PackageHR_GENERAL - show dependent code
SynonymHR_LOCATIONS_ALL_TL
ViewHR_LOCATIONS_NO_JOIN
ViewHR_LOOKUPS
ViewHR_ORGANIZATION_UNITS
PL/SQL PackageHR_SECURITY - show dependent code
SynonymHR_SOFT_CODING_KEYFLEX
ViewPAY_PAYROLLS_F
ViewPER_ASSIGNMENTS_F
SynonymPER_ASSIGNMENT_STATUS_TYPES
SynonymPER_ASSIGNMENT_STATUS_TYPES_TL
SynonymPER_ASS_STATUS_TYPE_AMENDS
SynonymPER_ASS_STATUS_TYPE_AMENDS_TL
SynonymPER_GRADES_TL
SynonymPER_JOBS_TL
SynonymPER_KR_GRADES
SynonymPER_KR_G_POINTS
SynonymPER_PAY_BASES

APPS.PER_KR_ASSIGNMENTS_V is not referenced by any database object