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_POSITION_EI_V

Object Details

Object Name:	GHR_MT_POSITION_EI_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	GHR.GHR_MT_POSITION_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	Process Date
MT_SOURCE	VARCHAR2	(30)		Source
MT_EFFECTIVE_DATE	DATE			Effective Date
MT_NAME	VARCHAR2	(255)		Name
MT_STATUS	VARCHAR2	(255)		Status
MT_PERSON_ID	VARCHAR2	(255)		Person ID
MT_TABLE_NAME	VARCHAR2	(255)		Table Name
MT_INFORMATION_TYPE	VARCHAR2	(255)		Information Type
MT_INTER_BG_TRANSFER	VARCHAR2	(255)		Inter BG Transfer
POSITION_EXTRA_INFO_ID	VARCHAR2	(255)		Position Extra Info ID
POSITION_ID	VARCHAR2	(255)		Position 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
POEI_ATTRIBUTE_CATEGORY	VARCHAR2	(255)		Attribute Category for Descriptive Flexfield Columns
POEI_ATTRIBUTE1	VARCHAR2	(255)		Descriptive Flexfield
POEI_ATTRIBUTE2	VARCHAR2	(255)		Descriptive Flexfield
POEI_ATTRIBUTE3	VARCHAR2	(255)		Descriptive Flexfield
POEI_ATTRIBUTE4	VARCHAR2	(255)		Descriptive Flexfield
POEI_ATTRIBUTE5	VARCHAR2	(255)		Descriptive Flexfield
POEI_ATTRIBUTE6	VARCHAR2	(255)		Descriptive Flexfield
POEI_ATTRIBUTE7	VARCHAR2	(255)		Descriptive Flexfield
POEI_ATTRIBUTE8	VARCHAR2	(255)		Descriptive Flexfield
POEI_ATTRIBUTE9	VARCHAR2	(255)		Descriptive Flexfield
POEI_ATTRIBUTE10	VARCHAR2	(255)		Descriptive Flexfield
POEI_ATTRIBUTE11	VARCHAR2	(255)		Descriptive Flexfield
POEI_ATTRIBUTE12	VARCHAR2	(255)		Descriptive Flexfield
POEI_ATTRIBUTE13	VARCHAR2	(255)		Descriptive Flexfield
POEI_ATTRIBUTE14	VARCHAR2	(255)		Descriptive Flexfield
POEI_ATTRIBUTE15	VARCHAR2	(255)		Descriptive Flexfield
POEI_ATTRIBUTE16	VARCHAR2	(255)		Descriptive Flexfield
POEI_ATTRIBUTE17	VARCHAR2	(255)		Descriptive Flexfield
POEI_ATTRIBUTE18	VARCHAR2	(255)		Descriptive Flexfield
POEI_ATTRIBUTE19	VARCHAR2	(255)		Descriptive Flexfield
POEI_ATTRIBUTE20	VARCHAR2	(255)		Descriptive Flexfield
POEI_INFORMATION_CATEGORY	VARCHAR2	(255)		Information Category for Developer Descriptive Flexfield
POEI_INFORMATION1	VARCHAR2	(255)		Developer Descriptive Flexfield
POEI_INFORMATION2	VARCHAR2	(255)		Developer Descriptive Flexfield
POEI_INFORMATION3	VARCHAR2	(255)		Developer Descriptive Flexfield
POEI_INFORMATION4	VARCHAR2	(255)		Developer Descriptive Flexfield
POEI_INFORMATION5	VARCHAR2	(255)		Developer Descriptive Flexfield
POEI_INFORMATION6	VARCHAR2	(255)		Developer Descriptive Flexfield
POEI_INFORMATION7	VARCHAR2	(255)		Developer Descriptive Flexfield
POEI_INFORMATION8	VARCHAR2	(255)		Developer Descriptive Flexfield
POEI_INFORMATION9	VARCHAR2	(255)		Developer Descriptive Flexfield
POEI_INFORMATION10	VARCHAR2	(255)		Developer Descriptive Flexfield
POEI_INFORMATION11	VARCHAR2	(255)		Developer Descriptive Flexfield
POEI_INFORMATION12	VARCHAR2	(255)		Developer Descriptive Flexfield
POEI_INFORMATION13	VARCHAR2	(255)		Developer Descriptive Flexfield
POEI_INFORMATION14	VARCHAR2	(255)		Developer Descriptive Flexfield
POEI_INFORMATION15	VARCHAR2	(255)		Developer Descriptive Flexfield
POEI_INFORMATION16	VARCHAR2	(255)		Developer Descriptive Flexfield
POEI_INFORMATION17	VARCHAR2	(255)		Developer Descriptive Flexfield
POEI_INFORMATION18	VARCHAR2	(255)		Developer Descriptive Flexfield
POEI_INFORMATION19	VARCHAR2	(255)		Developer Descriptive Flexfield
POEI_INFORMATION20	VARCHAR2	(255)		Developer Descriptive Flexfield
POEI_INFORMATION21	VARCHAR2	(255)		Developer Descriptive Flexfield
POEI_INFORMATION22	VARCHAR2	(255)		Developer Descriptive Flexfield
POEI_INFORMATION23	VARCHAR2	(255)		Developer Descriptive Flexfield
POEI_INFORMATION24	VARCHAR2	(255)		Developer Descriptive Flexfield
POEI_INFORMATION25	VARCHAR2	(255)		Developer Descriptive Flexfield
POEI_INFORMATION26	VARCHAR2	(255)		Developer Descriptive Flexfield
POEI_INFORMATION27	VARCHAR2	(255)		Developer Descriptive Flexfield
POEI_INFORMATION28	VARCHAR2	(255)		Developer Descriptive Flexfield
POEI_INFORMATION29	VARCHAR2	(255)		Developer Descriptive Flexfield
POEI_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
,      POSITION_EXTRA_INFO_ID
,      POSITION_ID
,      INFORMATION_TYPE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      POEI_ATTRIBUTE_CATEGORY
,      POEI_ATTRIBUTE1
,      POEI_ATTRIBUTE2
,      POEI_ATTRIBUTE3
,      POEI_ATTRIBUTE4
,      POEI_ATTRIBUTE5
,      POEI_ATTRIBUTE6
,      POEI_ATTRIBUTE7
,      POEI_ATTRIBUTE8
,      POEI_ATTRIBUTE9
,      POEI_ATTRIBUTE10
,      POEI_ATTRIBUTE11
,      POEI_ATTRIBUTE12
,      POEI_ATTRIBUTE13
,      POEI_ATTRIBUTE14
,      POEI_ATTRIBUTE15
,      POEI_ATTRIBUTE16
,      POEI_ATTRIBUTE17
,      POEI_ATTRIBUTE18
,      POEI_ATTRIBUTE19
,      POEI_ATTRIBUTE20
,      POEI_INFORMATION_CATEGORY
,      POEI_INFORMATION1
,      POEI_INFORMATION2
,      POEI_INFORMATION3
,      POEI_INFORMATION4
,      POEI_INFORMATION5
,      POEI_INFORMATION6
,      POEI_INFORMATION7
,      POEI_INFORMATION8
,      POEI_INFORMATION9
,      POEI_INFORMATION10
,      POEI_INFORMATION11
,      POEI_INFORMATION12
,      POEI_INFORMATION13
,      POEI_INFORMATION14
,      POEI_INFORMATION15
,      POEI_INFORMATION16
,      POEI_INFORMATION17
,      POEI_INFORMATION18
,      POEI_INFORMATION19
,      POEI_INFORMATION20
,      POEI_INFORMATION21
,      POEI_INFORMATION22
,      POEI_INFORMATION23
,      POEI_INFORMATION24
,      POEI_INFORMATION25
,      POEI_INFORMATION26
,      POEI_INFORMATION27
,      POEI_INFORMATION28
,      POEI_INFORMATION29
,      POEI_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_POSITION_EI_V;

Dependencies

[top of page]

APPS.GHR_MT_POSITION_EI_V references the following:

APPS: GHR_INTERFACE

APPS.GHR_MT_POSITION_EI_V is referenced by following:

APPS: GHR_MTO_INT - show dependent code; GHR_MT_INTERFACE_V