[Home] [Help] [Dependency Information]
Object Name: | PER_PREV_JOB_EXTRA_INFO_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PER.PER_PREV_JOB_EXTRA_INFO_V |
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 |
---|---|---|---|---|
PREVIOUS_JOB_EXTRA_INFO_ID | NUMBER | (15) | Yes | This is the Surrogate ID for Previous Job record |
PREVIOUS_JOB_ID | NUMBER | (15) | Yes | This is the FK of the previous job to which previous job usage record applies |
INFORMATION_TYPE | VARCHAR2 | (40) | Yes | Information type for this extra job information |
PJI_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Attribute Category | |
PJI_ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield | |
PJI_ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield | |
PJI_ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield | |
PJI_ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield | |
PJI_ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield | |
PJI_ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield | |
PJI_ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield | |
PJI_ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield | |
PJI_ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield | |
PJI_ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield | |
PJI_ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield | |
PJI_ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield | |
PJI_ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield | |
PJI_ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield | |
PJI_ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield | |
PJI_ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive Flexfield | |
PJI_ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive Flexfield | |
PJI_ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive Flexfield | |
PJI_ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive Flexfield | |
PJI_ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive Flexfield | |
PJI_ATTRIBUTE21 | VARCHAR2 | (150) | Descriptive Flexfield | |
PJI_ATTRIBUTE22 | VARCHAR2 | (150) | Descriptive Flexfield | |
PJI_ATTRIBUTE23 | VARCHAR2 | (150) | Descriptive Flexfield | |
PJI_ATTRIBUTE24 | VARCHAR2 | (150) | Descriptive Flexfield | |
PJI_ATTRIBUTE25 | VARCHAR2 | (150) | Descriptive Flexfield | |
PJI_ATTRIBUTE26 | VARCHAR2 | (150) | Descriptive Flexfield | |
PJI_ATTRIBUTE27 | VARCHAR2 | (150) | Descriptive Flexfield | |
PJI_ATTRIBUTE28 | VARCHAR2 | (150) | Descriptive Flexfield | |
PJI_ATTRIBUTE29 | VARCHAR2 | (150) | Descriptive Flexfield | |
PJI_ATTRIBUTE30 | VARCHAR2 | (150) | Descriptive Flexfield | |
PJI_INFORMATION_CATEGORY | VARCHAR2 | (30) | Developer Descriptive Flexfield Inforamtion Category | |
PJI_INFORMATION1 | VARCHAR2 | (150) | Developer Descriptive Flexfield | |
PJI_INFORMATION2 | VARCHAR2 | (150) | Developer Descriptive Flexfield | |
PJI_INFORMATION3 | VARCHAR2 | (150) | Developer Descriptive Flexfield | |
PJI_INFORMATION4 | VARCHAR2 | (150) | Developer Descriptive Flexfield | |
PJI_INFORMATION5 | VARCHAR2 | (150) | Developer Descriptive Flexfield | |
PJI_INFORMATION6 | VARCHAR2 | (150) | Developer Descriptive Flexfield | |
PJI_INFORMATION7 | VARCHAR2 | (150) | Developer Descriptive Flexfield | |
PJI_INFORMATION8 | VARCHAR2 | (150) | Developer Descriptive Flexfield | |
PJI_INFORMATION9 | VARCHAR2 | (150) | Developer Descriptive Flexfield | |
PJI_INFORMATION10 | VARCHAR2 | (150) | Developer Descriptive Flexfield | |
PJI_INFORMATION11 | VARCHAR2 | (150) | Developer Descriptive Flexfield | |
PJI_INFORMATION12 | VARCHAR2 | (150) | Developer Descriptive Flexfield | |
PJI_INFORMATION13 | VARCHAR2 | (150) | Developer Descriptive Flexfield | |
PJI_INFORMATION14 | VARCHAR2 | (150) | Developer Descriptive Flexfield | |
PJI_INFORMATION15 | VARCHAR2 | (150) | Developer Descriptive Flexfield | |
PJI_INFORMATION16 | VARCHAR2 | (150) | Developer Descriptive Flexfield | |
PJI_INFORMATION17 | VARCHAR2 | (150) | Developer Descriptive Flexfield | |
PJI_INFORMATION18 | VARCHAR2 | (150) | Developer Descriptive Flexfield | |
PJI_INFORMATION19 | VARCHAR2 | (150) | Developer Descriptive Flexfield | |
PJI_INFORMATION20 | VARCHAR2 | (150) | Developer Descriptive Flexfield | |
PJI_INFORMATION21 | VARCHAR2 | (150) | Developer Descriptive Flexfield | |
PJI_INFORMATION22 | VARCHAR2 | (150) | Developer Descriptive Flexfield | |
PJI_INFORMATION23 | VARCHAR2 | (150) | Developer Descriptive Flexfield | |
PJI_INFORMATION24 | VARCHAR2 | (150) | Developer Descriptive Flexfield | |
PJI_INFORMATION25 | VARCHAR2 | (150) | Developer Descriptive Flexfield | |
PJI_INFORMATION26 | VARCHAR2 | (150) | Developer Descriptive Flexfield | |
PJI_INFORMATION27 | VARCHAR2 | (150) | Developer Descriptive Flexfield | |
PJI_INFORMATION28 | VARCHAR2 | (150) | Developer Descriptive Flexfield | |
PJI_INFORMATION29 | VARCHAR2 | (150) | Developer Descriptive Flexfield | |
PJI_INFORMATION30 | VARCHAR2 | (150) | Developer Descriptive Flexfield | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Used to store object version number |
LAST_UPDATE_DATE | DATE | Yes | Standard WHO columns | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Developer Descriptive Flexfield |
LAST_UPDATE_LOGIN | NUMBER | (15) | Developer Descriptive Flexfield | |
CREATED_BY | NUMBER | (15) | Yes | Developer Descriptive Flexfield |
CREATION_DATE | DATE | Yes | Developer Descriptive Flexfield |
Cut, paste (and edit) the following text to query this object:
SELECT PREVIOUS_JOB_EXTRA_INFO_ID
, PREVIOUS_JOB_ID
, INFORMATION_TYPE
, PJI_ATTRIBUTE_CATEGORY
, PJI_ATTRIBUTE1
, PJI_ATTRIBUTE2
, PJI_ATTRIBUTE3
, PJI_ATTRIBUTE4
, PJI_ATTRIBUTE5
, PJI_ATTRIBUTE6
, PJI_ATTRIBUTE7
, PJI_ATTRIBUTE8
, PJI_ATTRIBUTE9
, PJI_ATTRIBUTE10
, PJI_ATTRIBUTE11
, PJI_ATTRIBUTE12
, PJI_ATTRIBUTE13
, PJI_ATTRIBUTE14
, PJI_ATTRIBUTE15
, PJI_ATTRIBUTE16
, PJI_ATTRIBUTE17
, PJI_ATTRIBUTE18
, PJI_ATTRIBUTE19
, PJI_ATTRIBUTE20
, PJI_ATTRIBUTE21
, PJI_ATTRIBUTE22
, PJI_ATTRIBUTE23
, PJI_ATTRIBUTE24
, PJI_ATTRIBUTE25
, PJI_ATTRIBUTE26
, PJI_ATTRIBUTE27
, PJI_ATTRIBUTE28
, PJI_ATTRIBUTE29
, PJI_ATTRIBUTE30
, PJI_INFORMATION_CATEGORY
, PJI_INFORMATION1
, PJI_INFORMATION2
, PJI_INFORMATION3
, PJI_INFORMATION4
, PJI_INFORMATION5
, PJI_INFORMATION6
, PJI_INFORMATION7
, PJI_INFORMATION8
, PJI_INFORMATION9
, PJI_INFORMATION10
, PJI_INFORMATION11
, PJI_INFORMATION12
, PJI_INFORMATION13
, PJI_INFORMATION14
, PJI_INFORMATION15
, PJI_INFORMATION16
, PJI_INFORMATION17
, PJI_INFORMATION18
, PJI_INFORMATION19
, PJI_INFORMATION20
, PJI_INFORMATION21
, PJI_INFORMATION22
, PJI_INFORMATION23
, PJI_INFORMATION24
, PJI_INFORMATION25
, PJI_INFORMATION26
, PJI_INFORMATION27
, PJI_INFORMATION28
, PJI_INFORMATION29
, PJI_INFORMATION30
, OBJECT_VERSION_NUMBER
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
FROM APPS.PER_PREV_JOB_EXTRA_INFO_V;
APPS.PER_PREV_JOB_EXTRA_INFO_V is not referenced by any database object
|
|
|