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

VIEW: APPS.PER_JOB_API_V

Object Details
Object Name: PER_JOB_API_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPER.PER_JOB_API_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
JOB_ID NUMBER (15) Yes System-generated primary key column.
BUSINESS_GROUP_ID NUMBER (15) Yes Foreign key to HR_ORGANIZATION_UNITS.
JOB_DEFINITION_ID NUMBER (15) Yes Foreign key to PER_JOB_DEFINITIONS.
DATE_FROM DATE
Yes Date from which an employee or applicant may be assigned to this job.
COMMENTS CLOB (4000)
General remark.
DATE_TO DATE

Date after which employees and applicants may no longer be assigned to this job.
NAME VARCHAR2 (700)
Job name, concatenated from the keyflex structure.
REQUEST_ID NUMBER (15)
Standard Who column.
PROGRAM_APPLICATION_ID NUMBER (15)
Standard Who column.
PROGRAM_ID NUMBER (15)
Standard Who column.
PROGRAM_UPDATE_DATE DATE

Standard Who column.
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column.
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.
LAST_UPDATE_DATE DATE

Standard Who column.
LAST_UPDATED_BY NUMBER (15)
Standard Who column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column.
CREATED_BY NUMBER (15)
Standard Who column.
CREATION_DATE DATE

Standard Who column.
JOB_INFORMATION_CATEGORY VARCHAR2 (30)
Developer descriptive flexfield column.
JOB_INFORMATION1 VARCHAR2 (150)
Developer descriptive flexfield column.
JOB_INFORMATION2 VARCHAR2 (150)
Developer descriptive flexfield column.
JOB_INFORMATION3 VARCHAR2 (150)
Developer descriptive flexfield column.
JOB_INFORMATION4 VARCHAR2 (150)
Developer descriptive flexfield column.
JOB_INFORMATION5 VARCHAR2 (150)
Developer descriptive flexfield column.
JOB_INFORMATION6 VARCHAR2 (150)
Developer descriptive flexfield column.
JOB_INFORMATION7 VARCHAR2 (150)
Developer descriptive flexfield column.
JOB_INFORMATION8 VARCHAR2 (150)
Developer descriptive flexfield column.
JOB_INFORMATION9 VARCHAR2 (150)
Developer descriptive flexfield column.
JOB_INFORMATION10 VARCHAR2 (150)
Developer descriptive flexfield column.
JOB_INFORMATION11 VARCHAR2 (150)
Developer descriptive flexfield column.
JOB_INFORMATION12 VARCHAR2 (150)
Developer descriptive flexfield column.
JOB_INFORMATION13 VARCHAR2 (150)
Developer descriptive flexfield column.
JOB_INFORMATION14 VARCHAR2 (150)
Developer descriptive flexfield column.
JOB_INFORMATION15 VARCHAR2 (150)
Developer descriptive flexfield column.
OBJECT_VERSION_NUMBER NUMBER (9)
System-generated version of row. Increments by one with each update.
JOB_INFORMATION16 VARCHAR2 (150)
Developer descriptive flexfield column.
JOB_INFORMATION17 VARCHAR2 (150)
Developer descriptive flexfield column.
JOB_INFORMATION18 VARCHAR2 (150)
Developer descriptive flexfield column.
JOB_INFORMATION19 VARCHAR2 (150)
Developer descriptive flexfield column.
JOB_INFORMATION20 VARCHAR2 (150)
Developer descriptive flexfield column.
BENCHMARK_JOB_FLAG VARCHAR2 (30)
Benchmark Job Flag
BENCHMARK_JOB_ID NUMBER (15)
Benchmark Job Id.
EMP_RIGHTS_FLAG VARCHAR2 (30)
Additional employee rights.
JOB_GROUP_ID NUMBER (15) Yes Foreign key to per_job_groups.
APPROVAL_AUTHORITY NUMBER (38)
Approval Authority used by OAM
ID_FLEX_NUM NUMBER (15) Yes Key flexfield structure foreign key.
SUMMARY_FLAG VARCHAR2 (1) Yes Key flexfield summary flag.
ENABLED_FLAG VARCHAR2 (1) Yes Key flexfield enabled flag.
START_DATE_ACTIVE DATE

Date before which key flexfield combination is invalid.
END_DATE_ACTIVE DATE

Date after which key flexfield combination is invalid.
SEGMENT1 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT2 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT3 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT4 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT5 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT6 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT7 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT8 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT9 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT10 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT11 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT12 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT13 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT14 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT15 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT16 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT17 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT18 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT19 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT20 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT21 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT22 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT23 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT24 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT25 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT26 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT27 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT28 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT29 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT30 VARCHAR2 (60)
Key flexfield segment column.
Query Text

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


SELECT JOB_ID
,      BUSINESS_GROUP_ID
,      JOB_DEFINITION_ID
,      DATE_FROM
,      COMMENTS
,      DATE_TO
,      NAME
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      JOB_INFORMATION_CATEGORY
,      JOB_INFORMATION1
,      JOB_INFORMATION2
,      JOB_INFORMATION3
,      JOB_INFORMATION4
,      JOB_INFORMATION5
,      JOB_INFORMATION6
,      JOB_INFORMATION7
,      JOB_INFORMATION8
,      JOB_INFORMATION9
,      JOB_INFORMATION10
,      JOB_INFORMATION11
,      JOB_INFORMATION12
,      JOB_INFORMATION13
,      JOB_INFORMATION14
,      JOB_INFORMATION15
,      OBJECT_VERSION_NUMBER
,      JOB_INFORMATION16
,      JOB_INFORMATION17
,      JOB_INFORMATION18
,      JOB_INFORMATION19
,      JOB_INFORMATION20
,      BENCHMARK_JOB_FLAG
,      BENCHMARK_JOB_ID
,      EMP_RIGHTS_FLAG
,      JOB_GROUP_ID
,      APPROVAL_AUTHORITY
,      ID_FLEX_NUM
,      SUMMARY_FLAG
,      ENABLED_FLAG
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      SEGMENT1
,      SEGMENT2
,      SEGMENT3
,      SEGMENT4
,      SEGMENT5
,      SEGMENT6
,      SEGMENT7
,      SEGMENT8
,      SEGMENT9
,      SEGMENT10
,      SEGMENT11
,      SEGMENT12
,      SEGMENT13
,      SEGMENT14
,      SEGMENT15
,      SEGMENT16
,      SEGMENT17
,      SEGMENT18
,      SEGMENT19
,      SEGMENT20
,      SEGMENT21
,      SEGMENT22
,      SEGMENT23
,      SEGMENT24
,      SEGMENT25
,      SEGMENT26
,      SEGMENT27
,      SEGMENT28
,      SEGMENT29
,      SEGMENT30
FROM APPS.PER_JOB_API_V;

Dependencies

[top of page]

APPS.PER_JOB_API_V references the following:

SchemaAPPS
SynonymPER_JOBS
SynonymPER_JOB_DEFINITIONS

APPS.PER_JOB_API_V is not referenced by any database object