[Home] [Help] [Dependency Information]
Object Name: | HR_PTL_SUMMARY_DATA |
---|---|
Object Type: | TABLE |
Owner: | HR |
FND Design Data: | PER.HR_PTL_SUMMARY_DATA |
Subobject Name: | |
Status: | VALID |
Tablespace: | |
---|---|
PCT Free: | |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
HR_PTL_SUMMARY_DATA_N1 | NORMAL | NONUNIQUE |
SUMMARY_CONTEXT_TYPE
SUMMARY_CONTEXT_ID EFFECTIVE_DATE SUM_INFORMATION3 | |
HR_PTL_SUMMARY_DATA_N2 | NORMAL | NONUNIQUE |
SUMMARY_CONTEXT_ID
EFFECTIVE_DATE | |
HR_PTL_SUMMARY_DATA_N3 | NORMAL | NONUNIQUE |
SUM_INFORMATION1
SUM_INFORMATION2 SUM_INFORMATION3 | |
HR_PTL_SUMMARY_DATA_N4 | NORMAL | NONUNIQUE |
SUMMARY_CONTEXT_ID
SUM_INFORMATION1 EFFECTIVE_DATE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SUMMARY_DATA_ID | NUMBER | (9) | Yes | |
SUMMARY_CONTEXT_TYPE | VARCHAR2 | (30) | Yes | |
SUMMARY_CONTEXT_ID | NUMBER | (15) | Yes | |
EFFECTIVE_DATE | DATE | |||
EFFECTIVE_END_DATE | DATE | |||
CREATED_BY | NUMBER | (9) | Yes | |
CREATION_DATE | DATE | Yes | ||
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | |
LAST_UPDATED_BY | NUMBER | (9) | ||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATE_LOGIN | NUMBER | (9) | ||
REQUEST_ID | NUMBER | (15) | ||
PROGRAM_APPLICATION_ID | NUMBER | (15) | ||
PROGRAM_ID | NUMBER | (15) | ||
PROGRAM_UPDATE_DATE | DATE | |||
SOURCE_TYPE | VARCHAR2 | (30) | ||
SUM_INFORMATION_CATEGORY | VARCHAR2 | (30) | Yes | |
SUM_INFORMATION1 | VARCHAR2 | (150) | ||
SUM_INFORMATION2 | VARCHAR2 | (150) | ||
SUM_INFORMATION3 | VARCHAR2 | (150) | ||
SUM_INFORMATION4 | VARCHAR2 | (150) | ||
SUM_INFORMATION5 | VARCHAR2 | (150) | ||
SUM_INFORMATION6 | VARCHAR2 | (150) | ||
SUM_INFORMATION7 | VARCHAR2 | (150) | ||
SUM_INFORMATION8 | VARCHAR2 | (150) | ||
SUM_INFORMATION9 | VARCHAR2 | (150) | ||
SUM_INFORMATION10 | VARCHAR2 | (150) | ||
SUM_INFORMATION11 | VARCHAR2 | (150) | ||
SUM_INFORMATION12 | VARCHAR2 | (150) | ||
SUM_INFORMATION13 | VARCHAR2 | (150) | ||
SUM_INFORMATION14 | VARCHAR2 | (150) | ||
SUM_INFORMATION15 | VARCHAR2 | (150) | ||
SUM_INFORMATION16 | VARCHAR2 | (150) | ||
SUM_INFORMATION17 | VARCHAR2 | (150) | ||
SUM_INFORMATION18 | VARCHAR2 | (150) | ||
SUM_INFORMATION19 | VARCHAR2 | (150) | ||
SUM_INFORMATION20 | VARCHAR2 | (150) | ||
SUM_INFORMATION21 | VARCHAR2 | (150) | ||
SUM_INFORMATION22 | VARCHAR2 | (150) | ||
SUM_INFORMATION23 | VARCHAR2 | (150) | ||
SUM_INFORMATION24 | VARCHAR2 | (150) | ||
SUM_INFORMATION25 | VARCHAR2 | (150) | ||
SUM_INFORMATION26 | VARCHAR2 | (150) | ||
SUM_INFORMATION27 | VARCHAR2 | (150) | ||
SUM_INFORMATION28 | VARCHAR2 | (150) | ||
SUM_INFORMATION29 | VARCHAR2 | (150) | ||
SUM_INFORMATION30 | VARCHAR2 | (150) | ||
SUM_INFORMATION31 | VARCHAR2 | (150) | ||
SUM_INFORMATION32 | VARCHAR2 | (150) | ||
SUM_INFORMATION33 | VARCHAR2 | (150) | ||
SUM_INFORMATION34 | VARCHAR2 | (150) | ||
SUM_INFORMATION35 | VARCHAR2 | (150) | ||
SUM_INFORMATION36 | VARCHAR2 | (150) | ||
SUM_INFORMATION37 | VARCHAR2 | (150) | ||
SUM_INFORMATION38 | VARCHAR2 | (150) | ||
SUM_INFORMATION39 | VARCHAR2 | (150) | ||
SUM_INFORMATION40 | VARCHAR2 | (150) |
Cut, paste (and edit) the following text to query this object:
SELECT SUMMARY_DATA_ID
, SUMMARY_CONTEXT_TYPE
, SUMMARY_CONTEXT_ID
, EFFECTIVE_DATE
, EFFECTIVE_END_DATE
, CREATED_BY
, CREATION_DATE
, OBJECT_VERSION_NUMBER
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, SOURCE_TYPE
, SUM_INFORMATION_CATEGORY
, SUM_INFORMATION1
, SUM_INFORMATION2
, SUM_INFORMATION3
, SUM_INFORMATION4
, SUM_INFORMATION5
, SUM_INFORMATION6
, SUM_INFORMATION7
, SUM_INFORMATION8
, SUM_INFORMATION9
, SUM_INFORMATION10
, SUM_INFORMATION11
, SUM_INFORMATION12
, SUM_INFORMATION13
, SUM_INFORMATION14
, SUM_INFORMATION15
, SUM_INFORMATION16
, SUM_INFORMATION17
, SUM_INFORMATION18
, SUM_INFORMATION19
, SUM_INFORMATION20
, SUM_INFORMATION21
, SUM_INFORMATION22
, SUM_INFORMATION23
, SUM_INFORMATION24
, SUM_INFORMATION25
, SUM_INFORMATION26
, SUM_INFORMATION27
, SUM_INFORMATION28
, SUM_INFORMATION29
, SUM_INFORMATION30
, SUM_INFORMATION31
, SUM_INFORMATION32
, SUM_INFORMATION33
, SUM_INFORMATION34
, SUM_INFORMATION35
, SUM_INFORMATION36
, SUM_INFORMATION37
, SUM_INFORMATION38
, SUM_INFORMATION39
, SUM_INFORMATION40
FROM HR.HR_PTL_SUMMARY_DATA;
HR.HR_PTL_SUMMARY_DATA does not reference any database object
HR.HR_PTL_SUMMARY_DATA is referenced by following:
|
|
|