[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PER_JOBS_VL |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  PER.PER_JOBS_VL
|
| Subobject Name: | |
| Status: | VALID |
MultiLingual view (a language resolved view of the data.)
Single language join of PER_JOBS and PER_JOBS_TL
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ROW_ID | ROWID | (10) | Internal row identifier. | |
| JOB_ID | NUMBER | (15) | Yes | Column selected from base table per_jobs |
| BUSINESS_GROUP_ID | NUMBER | (15) | Yes | Column selected from base table per_jobs |
| JOB_DEFINITION_ID | NUMBER | (15) | Yes | Column selected from base table per_jobs |
| DATE_FROM | DATE | Yes | Column selected from base table per_jobs | |
| COMMENTS | CLOB | (4000) | Column selected from base table per_jobs | |
| DATE_TO | DATE | Column selected from base table per_jobs | ||
| NAME | VARCHAR2 | (700) | Translated name of job, selected from per_jobs_tl | |
| REQUEST_ID | NUMBER | (15) | Column selected from base table per_jobs | |
| PROGRAM_APPLICATION_ID | NUMBER | (15) | Column selected from base table per_jobs | |
| PROGRAM_ID | NUMBER | (15) | Column selected from base table per_jobs | |
| PROGRAM_UPDATE_DATE | DATE | Column selected from base table per_jobs | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Column selected from base table per_jobs | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Column selected from base table per_jobs | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Column selected from base table per_jobs | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Column selected from base table per_jobs | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Column selected from base table per_jobs | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Column selected from base table per_jobs | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Column selected from base table per_jobs | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Column selected from base table per_jobs | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Column selected from base table per_jobs | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Column selected from base table per_jobs | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Column selected from base table per_jobs | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Column selected from base table per_jobs | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Column selected from base table per_jobs | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Column selected from base table per_jobs | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Column selected from base table per_jobs | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Column selected from base table per_jobs | |
| ATTRIBUTE16 | VARCHAR2 | (150) | Column selected from base table per_jobs | |
| ATTRIBUTE17 | VARCHAR2 | (150) | Column selected from base table per_jobs | |
| ATTRIBUTE18 | VARCHAR2 | (150) | Column selected from base table per_jobs | |
| ATTRIBUTE19 | VARCHAR2 | (150) | Column selected from base table per_jobs | |
| ATTRIBUTE20 | VARCHAR2 | (150) | Column selected from base table per_jobs | |
| LAST_UPDATE_DATE | DATE | Column selected from base table per_jobs | ||
| LAST_UPDATED_BY | NUMBER | (15) | Column selected from base table per_jobs | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Column selected from base table per_jobs | |
| CREATED_BY | NUMBER | (15) | Column selected from base table per_jobs | |
| CREATION_DATE | DATE | Column selected from base table per_jobs | ||
| JOB_INFORMATION_CATEGORY | VARCHAR2 | (30) | Column selected from base table per_jobs | |
| JOB_INFORMATION1 | VARCHAR2 | (150) | Column selected from base table per_jobs | |
| JOB_INFORMATION2 | VARCHAR2 | (150) | Column selected from base table per_jobs | |
| JOB_INFORMATION3 | VARCHAR2 | (150) | Column selected from base table per_jobs | |
| JOB_INFORMATION4 | VARCHAR2 | (150) | Column selected from base table per_jobs | |
| JOB_INFORMATION5 | VARCHAR2 | (150) | Column selected from base table per_jobs | |
| JOB_INFORMATION6 | VARCHAR2 | (150) | Column selected from base table per_jobs | |
| JOB_INFORMATION7 | VARCHAR2 | (150) | Column selected from base table per_jobs | |
| JOB_INFORMATION8 | VARCHAR2 | (150) | Column selected from base table per_jobs | |
| JOB_INFORMATION9 | VARCHAR2 | (150) | Column selected from base table per_jobs | |
| JOB_INFORMATION10 | VARCHAR2 | (150) | Column selected from base table per_jobs | |
| JOB_INFORMATION11 | VARCHAR2 | (150) | Column selected from base table per_jobs | |
| JOB_INFORMATION12 | VARCHAR2 | (150) | Column selected from base table per_jobs | |
| JOB_INFORMATION13 | VARCHAR2 | (150) | Column selected from base table per_jobs | |
| JOB_INFORMATION14 | VARCHAR2 | (150) | Column selected from base table per_jobs | |
| JOB_INFORMATION15 | VARCHAR2 | (150) | Column selected from base table per_jobs | |
| JOB_INFORMATION16 | VARCHAR2 | (150) | Column selected from base table per_jobs | |
| JOB_INFORMATION17 | VARCHAR2 | (150) | Column selected from base table per_jobs | |
| JOB_INFORMATION18 | VARCHAR2 | (150) | Column selected from base table per_jobs | |
| JOB_INFORMATION19 | VARCHAR2 | (150) | Column selected from base table per_jobs | |
| JOB_INFORMATION20 | VARCHAR2 | (150) | Column selected from base table per_jobs | |
| OBJECT_VERSION_NUMBER | NUMBER | (9) | Column selected from base table per_jobs | |
| BENCHMARK_JOB_FLAG | VARCHAR2 | (30) | Column selected from base table per_jobs | |
| BENCHMARK_JOB_ID | NUMBER | (15) | Column selected from base table per_jobs | |
| EMP_RIGHTS_FLAG | VARCHAR2 | (30) | Column selected from base table per_jobs | |
| JOB_GROUP_ID | NUMBER | (15) | Yes | Column selected from base table per_jobs |
| APPROVAL_AUTHORITY | NUMBER | (38) | Column selected from base table per_jobs |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, 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
, JOB_INFORMATION16
, JOB_INFORMATION17
, JOB_INFORMATION18
, JOB_INFORMATION19
, JOB_INFORMATION20
, OBJECT_VERSION_NUMBER
, BENCHMARK_JOB_FLAG
, BENCHMARK_JOB_ID
, EMP_RIGHTS_FLAG
, JOB_GROUP_ID
, APPROVAL_AUTHORITY
FROM APPS.PER_JOBS_VL;
APPS
PER_JOBS
PER_JOBS_TL
APPS
BEN_ASSIGNMENT_D
BEN_ELIG_JOB_PRTE_D
BEN_ELIG_SUPPL_ROLE_PRTE_D
BEN_EXTRACT_SEED
- show dependent code
BEN_EXT_PERSON
- show dependent code
BEN_EXT_THREAD
- show dependent code
BEN_PD_RATE_AND_CVG_MODULE
- show dependent code
BEN_PLAN_DESIGN_ELPRO_MODULE
- show dependent code
BEN_PLAN_DESIGN_PROGRAM_MODULE
- show dependent code
HR_DYNAMIC_APPROVAL_WEB
- show dependent code
HR_GENERAL
- show dependent code
HR_MEE_VIEWS_GEN
- show dependent code
HR_MISC_WEB
- show dependent code
HR_OFFER_CUSTOM
- show dependent code
HR_PROCESS_ASSIGNMENT_SS
- show dependent code
HR_PUMP_GET
- show dependent code
HR_REPORTS
- show dependent code
HR_SUIT_MATCH_UTILITY_WEB
- show dependent code
HR_TERMINATION_SS
- show dependent code
IRC_OFFER_NOTIFICATIONS_PKG
- show dependent code
OTA_LEARNER_ACCESS_UTIL
- show dependent code
PAY_DB_PAY_SETUP
- show dependent code
PAY_EMP_ACTION_ARCH
- show dependent code
PAY_FR_DB_PAY_SETUP
- show dependent code
PAY_JP_ITWB_ARCHIVE_PKG
- show dependent code
PAY_PAYFV_ELEMENT_ENTRIES_PKG
- show dependent code
PER_APPLICANT_PKG
- show dependent code
PER_EEO_MAG_REPORT
- show dependent code
PER_JP_EMPDET_ARCHIVE_PKG
- show dependent code
PER_PERRPREQ_XMLP_PKG
- show dependent code
PER_PERUSADA_XMLP_PKG
- show dependent code
PER_PERUSEOX_XMLP_PKG
- show dependent code
PER_QH_FIND_QUERY
- show dependent code
PER_QH_POPULATE
- show dependent code
PER_SUC_BUS
- show dependent code
PER_US_VETS_100A_CONS_PKG
- show dependent code
PER_US_VETS_100A_LIST_PKG
- show dependent code
PER_US_VETS_100A_SINGLE_PKG
- show dependent code
POFV_BKT_PO_LINES
POFV_PO_LINES
POFV_REQUISITION_LINES
POFV_STD_PO_LINES
PON_PRINTING_PKG
- show dependent code
PON_SGD_AMD_LINES_V
PON_SGD_LINES_V
PON_VALIDATE_ITEM_PRICES_INT
- show dependent code
PO_APPROVAL_REMINDER_SV
- show dependent code
PO_COMMUNICATION_PVT
- show dependent code
PO_COPYDOC_SUB
- show dependent code
PO_NEGOTIATIONS_SV1
- show dependent code
PO_PDOI_LINE_PROCESS_PVT
- show dependent code
PO_POAPPROVAL_INIT1
- show dependent code
PO_PRICE_DIFFERENTIALS_PVT
- show dependent code
PO_SERVICES_PVT
- show dependent code
PO_SGD_LINES_V
PO_SGD_MOD_LINES_V
PO_VAL_LINES2
- show dependent code
PQH_COMMITMENT_PKG
- show dependent code
PQH_PQHUSEPR_XMLP_PKG
- show dependent code
PQH_PQHUSRCP_XMLP_PKG
- show dependent code
UMX_PROXY_USER_PVT
- show dependent code
UMX_PROXY_USER_PVT
- show dependent code
UMX_REGISTRATION_PVT
- show dependent code
|
|
|
|