[Home] [Help] [Dependency Information]
Object Name: | GHR_PA_REQUEST_EI_SHADOW |
---|---|
Object Type: | TABLE |
Owner: | HR |
FND Design Data: | GHR.GHR_PA_REQUEST_EI_SHADOW |
Subobject Name: | |
Status: | VALID |
Stores all the columns of the corresponding record of
GHR_PA_REQUEST_EXTRA_INFO. It stores only the
auotpopulated values for the corresponding columns and not the
values altered by the user on the RPA, so that it can be later on used
for comparisions to determine whehter or not to refresh the column on
the GHR_PA_REQUESTEXTRA_INFO.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GHR_PA_REQUEST_EI_SHADOW_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | PA_REQUEST_EXTRA_INFO_ID |
GHR_PA_REQUEST_EI_SHADOW_FK1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PA_REQUEST_ID |
GHR_PA_REQUEST_EI_SHADOW_FK2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | INFORMATION_TYPE |
Table | |
Foreign Table | Foreign Key Column | GHR_PA_REQUEST_EI_SHADOW | GHR_PA_REQUESTS | GHR_PA_REQUEST_EI_SHADOW PA_REQUEST_ID |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PA_REQUEST_EXTRA_INFO_ID | NUMBER | (15) | Yes | Foreign key to GHR_PA_REQUEST_EXTRA_INFO. |
PA_REQUEST_ID | NUMBER | (15) | Yes | Foreign key to GHR_PA_REQUESTS. |
INFORMATION_TYPE | VARCHAR2 | (40) | Yes | Foreign key to GHR_PA_REQUEST_INFO_TYPES. |
REI_INFORMATION1 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
REI_INFORMATION2 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
REI_INFORMATION3 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
REI_INFORMATION4 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
REI_INFORMATION5 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
REI_INFORMATION6 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
REI_INFORMATION7 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
REI_INFORMATION8 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
REI_INFORMATION9 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
REI_INFORMATION10 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
REI_INFORMATION11 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
REI_INFORMATION12 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
REI_INFORMATION13 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
REI_INFORMATION14 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
REI_INFORMATION15 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
REI_INFORMATION16 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
REI_INFORMATION17 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
REI_INFORMATION18 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
REI_INFORMATION19 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
REI_INFORMATION20 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
REI_INFORMATION21 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
REI_INFORMATION22 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
REI_INFORMATION28 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
REI_INFORMATION29 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
REI_INFORMATION23 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
REI_INFORMATION24 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
REI_INFORMATION25 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
REI_INFORMATION26 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
REI_INFORMATION27 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
REI_INFORMATION30 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
LAST_UPDATE_DATE | DATE | Yes | Standard who column. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column. |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column. | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column. |
CREATION_DATE | DATE | Yes | Standard who column. |
Cut, paste (and edit) the following text to query this object:
SELECT PA_REQUEST_EXTRA_INFO_ID
, PA_REQUEST_ID
, INFORMATION_TYPE
, REI_INFORMATION1
, REI_INFORMATION2
, REI_INFORMATION3
, REI_INFORMATION4
, REI_INFORMATION5
, REI_INFORMATION6
, REI_INFORMATION7
, REI_INFORMATION8
, REI_INFORMATION9
, REI_INFORMATION10
, REI_INFORMATION11
, REI_INFORMATION12
, REI_INFORMATION13
, REI_INFORMATION14
, REI_INFORMATION15
, REI_INFORMATION16
, REI_INFORMATION17
, REI_INFORMATION18
, REI_INFORMATION19
, REI_INFORMATION20
, REI_INFORMATION21
, REI_INFORMATION22
, REI_INFORMATION28
, REI_INFORMATION29
, REI_INFORMATION23
, REI_INFORMATION24
, REI_INFORMATION25
, REI_INFORMATION26
, REI_INFORMATION27
, REI_INFORMATION30
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
FROM HR.GHR_PA_REQUEST_EI_SHADOW;
HR.GHR_PA_REQUEST_EI_SHADOW does not reference any database object
HR.GHR_PA_REQUEST_EI_SHADOW is referenced by following:
|
|
|