eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.GHR_MT_PEOPLE_EI_V

Object Details

Object Name:	GHR_MT_PEOPLE_EI_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	GHR.GHR_MT_PEOPLE_EI_V
Subobject Name:
Status:	VALID

View Type

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.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
GHR_INTERFACE_ID	NUMBER	(15)	Yes	GHR Interface ID
MT_PROCESS_DATE	DATE		Yes	MT Process Date
MT_SOURCE	VARCHAR2	(30)		MT Source
MT_EFFECTIVE_DATE	DATE			MT Effective Date
MT_NAME	VARCHAR2	(255)		MT Name
MT_STATUS	VARCHAR2	(255)		MT Status
MT_PERSON_ID	VARCHAR2	(255)		MT Person ID
MT_TABLE_NAME	VARCHAR2	(255)		MT Table Name
MT_INFORMATION_TYPE	VARCHAR2	(255)		MT Information Type
MT_INTER_BG_TRANSFER	VARCHAR2	(255)		MT Inter BG Transfer
PERSON_EXTRA_INFO_ID	VARCHAR2	(255)		Person Extra Info ID
PERSON_ID	VARCHAR2	(255)		Person ID
INFORMATION_TYPE	VARCHAR2	(255)		Information Type
REQUEST_ID	VARCHAR2	(255)		Request ID
PROGRAM_APPLICATION_ID	VARCHAR2	(255)		Program Application ID
PROGRAM_ID	VARCHAR2	(255)		Program ID
PROGRAM_UPDATE_DATE	VARCHAR2	(255)		Program Update Date
PEI_ATTRIBUTE_CATEGORY	VARCHAR2	(255)		Attribute Category for Descriptive Flexfield columns
PEI_ATTRIBUTE1	VARCHAR2	(255)		Descriptive Flexfield
PEI_ATTRIBUTE2	VARCHAR2	(255)		Descriptive Flexfield
PEI_ATTRIBUTE3	VARCHAR2	(255)		Descriptive Flexfield
PEI_ATTRIBUTE4	VARCHAR2	(255)		Descriptive Flexfield
PEI_ATTRIBUTE5	VARCHAR2	(255)		Descriptive Flexfield
PEI_ATTRIBUTE6	VARCHAR2	(255)		Descriptive Flexfield
PEI_ATTRIBUTE7	VARCHAR2	(255)		Descriptive Flexfield
PEI_ATTRIBUTE8	VARCHAR2	(255)		Descriptive Flexfield
PEI_ATTRIBUTE9	VARCHAR2	(255)		Descriptive Flexfield
PEI_ATTRIBUTE10	VARCHAR2	(255)		Descriptive Flexfield
PEI_ATTRIBUTE11	VARCHAR2	(255)		Descriptive Flexfield
PEI_ATTRIBUTE12	VARCHAR2	(255)		Descriptive Flexfield
PEI_ATTRIBUTE13	VARCHAR2	(255)		Descriptive Flexfield
PEI_ATTRIBUTE14	VARCHAR2	(255)		Descriptive Flexfield
PEI_ATTRIBUTE15	VARCHAR2	(255)		Descriptive Flexfield
PEI_ATTRIBUTE16	VARCHAR2	(255)		Descriptive Flexfield
PEI_ATTRIBUTE17	VARCHAR2	(255)		Descriptive Flexfield
PEI_ATTRIBUTE18	VARCHAR2	(255)		Descriptive Flexfield
PEI_ATTRIBUTE19	VARCHAR2	(255)		Descriptive Flexfield
PEI_ATTRIBUTE20	VARCHAR2	(255)		Descriptive Flexfield
PEI_INFORMATION_CATEGORY	VARCHAR2	(255)		Information Category for Developer Descriptive Flexfield columns
PEI_INFORMATION1	VARCHAR2	(255)		Developer Descriptive Flexfield
PEI_INFORMATION2	VARCHAR2	(255)		Developer Descriptive Flexfield
PEI_INFORMATION3	VARCHAR2	(255)		Developer Descriptive Flexfield
PEI_INFORMATION4	VARCHAR2	(255)		Developer Descriptive Flexfield
PEI_INFORMATION5	VARCHAR2	(255)		Developer Descriptive Flexfield
PEI_INFORMATION6	VARCHAR2	(255)		Developer Descriptive Flexfield
PEI_INFORMATION7	VARCHAR2	(255)		Developer Descriptive Flexfield
PEI_INFORMATION8	VARCHAR2	(255)		Developer Descriptive Flexfield
PEI_INFORMATION9	VARCHAR2	(255)		Developer Descriptive Flexfield
PEI_INFORMATION10	VARCHAR2	(255)		Developer Descriptive Flexfield
PEI_INFORMATION11	VARCHAR2	(255)		Developer Descriptive Flexfield
PEI_INFORMATION12	VARCHAR2	(255)		Developer Descriptive Flexfield
PEI_INFORMATION13	VARCHAR2	(255)		Developer Descriptive Flexfield
PEI_INFORMATION14	VARCHAR2	(255)		Developer Descriptive Flexfield
PEI_INFORMATION15	VARCHAR2	(255)		Developer Descriptive Flexfield
PEI_INFORMATION16	VARCHAR2	(255)		Developer Descriptive Flexfield
PEI_INFORMATION17	VARCHAR2	(255)		Developer Descriptive Flexfield
PEI_INFORMATION18	VARCHAR2	(255)		Developer Descriptive Flexfield
PEI_INFORMATION19	VARCHAR2	(255)		Developer Descriptive Flexfield
PEI_INFORMATION20	VARCHAR2	(255)		Developer Descriptive Flexfield
PEI_INFORMATION21	VARCHAR2	(255)		Developer Descriptive Flexfield
PEI_INFORMATION22	VARCHAR2	(255)		Developer Descriptive Flexfield
PEI_INFORMATION23	VARCHAR2	(255)		Developer Descriptive Flexfield
PEI_INFORMATION24	VARCHAR2	(255)		Developer Descriptive Flexfield
PEI_INFORMATION25	VARCHAR2	(255)		Developer Descriptive Flexfield
PEI_INFORMATION26	VARCHAR2	(255)		Developer Descriptive Flexfield
PEI_INFORMATION27	VARCHAR2	(255)		Developer Descriptive Flexfield
PEI_INFORMATION28	VARCHAR2	(255)		Developer Descriptive Flexfield
PEI_INFORMATION29	VARCHAR2	(255)		Developer Descriptive Flexfield
PEI_INFORMATION30	VARCHAR2	(255)		Developer Descriptive Flexfield
OBJECT_VERSION_NUMBER	VARCHAR2	(255)		Object Version Number
LAST_UPDATE_DATE	VARCHAR2	(255)		Standard WHO Column
LAST_UPDATED_BY	VARCHAR2	(255)		Standard WHO Column
LAST_UPDATE_LOGIN	VARCHAR2	(255)		Standard WHO Column
CREATED_BY	VARCHAR2	(255)		Standard WHO Column
CREATION_DATE	VARCHAR2	(255)		Standard WHO Column
INFO3_MEANING	VARCHAR2	(255)		Info Meaning
INFO4_MEANING	VARCHAR2	(255)		Info Meaning
INFO5_MEANING	VARCHAR2	(255)		Info Meaning
INFO6_MEANING	VARCHAR2	(255)		Info Meaning
INFO7_MEANING	VARCHAR2	(255)		Info Meaning
INFO8_MEANING	VARCHAR2	(255)		Info Meaning
INFO9_MEANING	VARCHAR2	(255)		Info Meaning
INFO10_MEANING	VARCHAR2	(255)		Info Meaning
INFO11_MEANING	VARCHAR2	(255)		Info Meaning
INFO12_MEANING	VARCHAR2	(255)		Info Meaning
INFO13_MEANING	VARCHAR2	(255)		Info Meaning
INFO14_MEANING	VARCHAR2	(255)		Info Meaning
INFO15_MEANING	VARCHAR2	(255)		Info Meaning
INFO16_MEANING	VARCHAR2	(255)		Info Meaning
INFO17_MEANING	VARCHAR2	(255)		Info Meaning
INFO18_MEANING	VARCHAR2	(255)		Info Meaning
INFO19_MEANING	VARCHAR2	(255)		Info Meaning
INFO20_MEANING	VARCHAR2	(255)		Info Meaning
INFO21_MEANING	VARCHAR2	(255)		Info Meaning
INFO22_MEANING	VARCHAR2	(255)		Info Meaning
INFO23_MEANING	VARCHAR2	(255)		Info Meaning
INFO24_MEANING	VARCHAR2	(255)		Info Meaning
INFO25_MEANING	VARCHAR2	(255)		Info Meaning
INFO26_MEANING	VARCHAR2	(255)		Info Meaning
INFO27_MEANING	VARCHAR2	(255)		Info Meaning
INFO28_MEANING	VARCHAR2	(255)		Info Meaning
INFO29_MEANING	VARCHAR2	(255)		Info Meaning
INFO30_MEANING	VARCHAR2	(255)		Info Meaning
INFO31_MEANING	VARCHAR2	(255)		Info Meaning
INFO32_MEANING	VARCHAR2	(255)		Info Meaning

Query Text

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


SELECT GHR_INTERFACE_ID
,      MT_PROCESS_DATE
,      MT_SOURCE
,      MT_EFFECTIVE_DATE
,      MT_NAME
,      MT_STATUS
,      MT_PERSON_ID
,      MT_TABLE_NAME
,      MT_INFORMATION_TYPE
,      MT_INTER_BG_TRANSFER
,      PERSON_EXTRA_INFO_ID
,      PERSON_ID
,      INFORMATION_TYPE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      PEI_ATTRIBUTE_CATEGORY
,      PEI_ATTRIBUTE1
,      PEI_ATTRIBUTE2
,      PEI_ATTRIBUTE3
,      PEI_ATTRIBUTE4
,      PEI_ATTRIBUTE5
,      PEI_ATTRIBUTE6
,      PEI_ATTRIBUTE7
,      PEI_ATTRIBUTE8
,      PEI_ATTRIBUTE9
,      PEI_ATTRIBUTE10
,      PEI_ATTRIBUTE11
,      PEI_ATTRIBUTE12
,      PEI_ATTRIBUTE13
,      PEI_ATTRIBUTE14
,      PEI_ATTRIBUTE15
,      PEI_ATTRIBUTE16
,      PEI_ATTRIBUTE17
,      PEI_ATTRIBUTE18
,      PEI_ATTRIBUTE19
,      PEI_ATTRIBUTE20
,      PEI_INFORMATION_CATEGORY
,      PEI_INFORMATION1
,      PEI_INFORMATION2
,      PEI_INFORMATION3
,      PEI_INFORMATION4
,      PEI_INFORMATION5
,      PEI_INFORMATION6
,      PEI_INFORMATION7
,      PEI_INFORMATION8
,      PEI_INFORMATION9
,      PEI_INFORMATION10
,      PEI_INFORMATION11
,      PEI_INFORMATION12
,      PEI_INFORMATION13
,      PEI_INFORMATION14
,      PEI_INFORMATION15
,      PEI_INFORMATION16
,      PEI_INFORMATION17
,      PEI_INFORMATION18
,      PEI_INFORMATION19
,      PEI_INFORMATION20
,      PEI_INFORMATION21
,      PEI_INFORMATION22
,      PEI_INFORMATION23
,      PEI_INFORMATION24
,      PEI_INFORMATION25
,      PEI_INFORMATION26
,      PEI_INFORMATION27
,      PEI_INFORMATION28
,      PEI_INFORMATION29
,      PEI_INFORMATION30
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      INFO3_MEANING
,      INFO4_MEANING
,      INFO5_MEANING
,      INFO6_MEANING
,      INFO7_MEANING
,      INFO8_MEANING
,      INFO9_MEANING
,      INFO10_MEANING
,      INFO11_MEANING
,      INFO12_MEANING
,      INFO13_MEANING
,      INFO14_MEANING
,      INFO15_MEANING
,      INFO16_MEANING
,      INFO17_MEANING
,      INFO18_MEANING
,      INFO19_MEANING
,      INFO20_MEANING
,      INFO21_MEANING
,      INFO22_MEANING
,      INFO23_MEANING
,      INFO24_MEANING
,      INFO25_MEANING
,      INFO26_MEANING
,      INFO27_MEANING
,      INFO28_MEANING
,      INFO29_MEANING
,      INFO30_MEANING
,      INFO31_MEANING
,      INFO32_MEANING
FROM APPS.GHR_MT_PEOPLE_EI_V;

Dependencies

[top of page]

APPS.GHR_MT_PEOPLE_EI_V references the following:

APPS: GHR_INTERFACE

APPS.GHR_MT_PEOPLE_EI_V is referenced by following:

APPS: GHR_MTI_INT - show dependent code; GHR_MTO_INT - show dependent code; GHR_MT_INTERFACE_V