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_ASSIGNMENT_EI_V

Object Details

Object Name:	GHR_MT_ASSIGNMENT_EI_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	GHR.GHR_MT_ASSIGNMENT_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
ASSIGNMENT_EXTRA_INFO_ID	VARCHAR2	(255)		Assignment Extra Info ID
ASSIGNMENT_ID	VARCHAR2	(255)		Assignment 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
AEI_ATTRIBUTE_CATEGORY	VARCHAR2	(255)		Attribute Category for Descriptive Flexfield column
AEI_ATTRIBUTE1	VARCHAR2	(255)		Descriptive Flexfield
AEI_ATTRIBUTE2	VARCHAR2	(255)		Descriptive Flexfield
AEI_ATTRIBUTE3	VARCHAR2	(255)		Descriptive Flexfield
AEI_ATTRIBUTE4	VARCHAR2	(255)		Descriptive Flexfield
AEI_ATTRIBUTE5	VARCHAR2	(255)		Descriptive Flexfield
AEI_ATTRIBUTE6	VARCHAR2	(255)		Descriptive Flexfield
AEI_ATTRIBUTE7	VARCHAR2	(255)		Descriptive Flexfield
AEI_ATTRIBUTE8	VARCHAR2	(255)		Descriptive Flexfield
AEI_ATTRIBUTE9	VARCHAR2	(255)		Descriptive Flexfield
AEI_ATTRIBUTE10	VARCHAR2	(255)		Descriptive Flexfield
AEI_ATTRIBUTE11	VARCHAR2	(255)		Descriptive Flexfield
AEI_ATTRIBUTE12	VARCHAR2	(255)		Descriptive Flexfield
AEI_ATTRIBUTE13	VARCHAR2	(255)		Descriptive Flexfield
AEI_ATTRIBUTE14	VARCHAR2	(255)		Descriptive Flexfield
AEI_ATTRIBUTE15	VARCHAR2	(255)		Descriptive Flexfield
AEI_ATTRIBUTE16	VARCHAR2	(255)		Descriptive Flexfield
AEI_ATTRIBUTE17	VARCHAR2	(255)		Descriptive Flexfield
AEI_ATTRIBUTE18	VARCHAR2	(255)		Descriptive Flexfield
AEI_ATTRIBUTE19	VARCHAR2	(255)		Descriptive Flexfield
AEI_ATTRIBUTE20	VARCHAR2	(255)		Descriptive Flexfield
LAST_UPDATE_DATE	VARCHAR2	(255)		Who Column
LAST_UPDATED_BY	VARCHAR2	(255)		Who Column
LAST_UPDATE_LOGIN	VARCHAR2	(255)		Who Column
CREATED_BY	VARCHAR2	(255)		Who Column
CREATION_DATE	VARCHAR2	(255)		Who Column
AEI_INFORMATION_CATEGORY	VARCHAR2	(255)		Information Category for Developer Descriptive Flexfield
AEI_INFORMATION1	VARCHAR2	(255)		Developer Descriptive Flexfield
AEI_INFORMATION2	VARCHAR2	(255)		Developer Descriptive Flexfield
AEI_INFORMATION3	VARCHAR2	(255)		Developer Descriptive Flexfield
AEI_INFORMATION4	VARCHAR2	(255)		Developer Descriptive Flexfield
AEI_INFORMATION5	VARCHAR2	(255)		Developer Descriptive Flexfield
AEI_INFORMATION6	VARCHAR2	(255)		Developer Descriptive Flexfield
AEI_INFORMATION7	VARCHAR2	(255)		Developer Descriptive Flexfield
AEI_INFORMATION8	VARCHAR2	(255)		Developer Descriptive Flexfield
AEI_INFORMATION9	VARCHAR2	(255)		Developer Descriptive Flexfield
AEI_INFORMATION10	VARCHAR2	(255)		Developer Descriptive Flexfield
AEI_INFORMATION11	VARCHAR2	(255)		Developer Descriptive Flexfield
AEI_INFORMATION12	VARCHAR2	(255)		Developer Descriptive Flexfield
AEI_INFORMATION13	VARCHAR2	(255)		Developer Descriptive Flexfield
AEI_INFORMATION14	VARCHAR2	(255)		Developer Descriptive Flexfield
AEI_INFORMATION15	VARCHAR2	(255)		Developer Descriptive Flexfield
AEI_INFORMATION16	VARCHAR2	(255)		Developer Descriptive Flexfield
AEI_INFORMATION17	VARCHAR2	(255)		Developer Descriptive Flexfield
AEI_INFORMATION18	VARCHAR2	(255)		Developer Descriptive Flexfield
AEI_INFORMATION19	VARCHAR2	(255)		Developer Descriptive Flexfield
AEI_INFORMATION20	VARCHAR2	(255)		Developer Descriptive Flexfield
AEI_INFORMATION21	VARCHAR2	(255)		Developer Descriptive Flexfield
AEI_INFORMATION22	VARCHAR2	(255)		Developer Descriptive Flexfield
AEI_INFORMATION23	VARCHAR2	(255)		Developer Descriptive Flexfield
AEI_INFORMATION24	VARCHAR2	(255)		Developer Descriptive Flexfield
AEI_INFORMATION25	VARCHAR2	(255)		Developer Descriptive Flexfield
AEI_INFORMATION26	VARCHAR2	(255)		Developer Descriptive Flexfield
AEI_INFORMATION27	VARCHAR2	(255)		Developer Descriptive Flexfield
AEI_INFORMATION28	VARCHAR2	(255)		Developer Descriptive Flexfield
AEI_INFORMATION29	VARCHAR2	(255)		Developer Descriptive Flexfield
AEI_INFORMATION30	VARCHAR2	(255)		Developer Descriptive Flexfield
OBJECT_VERSION_NUMBER	VARCHAR2	(255)		Object Version Number
INFO3_MEANING	VARCHAR2	(255)		Info 3 Meaning
INFO4_MEANING	VARCHAR2	(255)		Info 3 Meaning
INFO5_MEANING	VARCHAR2	(255)		Info 3 Meaning
INFO6_MEANING	VARCHAR2	(255)		Info 3 Meaning
INFO7_MEANING	VARCHAR2	(255)		Info 7 Meaning
INFO8_MEANING	VARCHAR2	(255)		Info 8 Meaning
INFO9_MEANING	VARCHAR2	(255)		Info 9 Meaning
INFO10_MEANING	VARCHAR2	(255)		Info 10 Meaning
INFO11_MEANING	VARCHAR2	(255)		Info 11 Meaning
INFO12_MEANING	VARCHAR2	(255)		Info 12 Meaning
INFO13_MEANING	VARCHAR2	(255)		Info 13 Meaning
INFO14_MEANING	VARCHAR2	(255)		Info 14 Meaning
INFO15_MEANING	VARCHAR2	(255)		Info 15 Meaning
INFO16_MEANING	VARCHAR2	(255)		Info 16 Meaning
INFO17_MEANING	VARCHAR2	(255)		Info 17 Meaning
INFO18_MEANING	VARCHAR2	(255)		Info 18 Meaning
INFO19_MEANING	VARCHAR2	(255)		Info 19 Meaning
INFO20_MEANING	VARCHAR2	(255)		Info 20 Meaning
INFO21_MEANING	VARCHAR2	(255)		Info 21 Meaning
INFO22_MEANING	VARCHAR2	(255)		Info 22 Meaning
INFO23_MEANING	VARCHAR2	(255)		Info 23 Meaning
INFO24_MEANING	VARCHAR2	(255)		Info 24 Meaning
INFO25_MEANING	VARCHAR2	(255)		Info 25 Meaning
INFO26_MEANING	VARCHAR2	(255)		Info 26 Meaning
INFO27_MEANING	VARCHAR2	(255)		Info 27 Meaning
INFO28_MEANING	VARCHAR2	(255)		Info 28 Meaning
INFO29_MEANING	VARCHAR2	(255)		Info 29 Meaning
INFO30_MEANING	VARCHAR2	(255)		Info 30 Meaning
INFO31_MEANING	VARCHAR2	(255)		Info 31 Meaning
INFO32_MEANING	VARCHAR2	(255)		Info 32 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
,      ASSIGNMENT_EXTRA_INFO_ID
,      ASSIGNMENT_ID
,      INFORMATION_TYPE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      AEI_ATTRIBUTE_CATEGORY
,      AEI_ATTRIBUTE1
,      AEI_ATTRIBUTE2
,      AEI_ATTRIBUTE3
,      AEI_ATTRIBUTE4
,      AEI_ATTRIBUTE5
,      AEI_ATTRIBUTE6
,      AEI_ATTRIBUTE7
,      AEI_ATTRIBUTE8
,      AEI_ATTRIBUTE9
,      AEI_ATTRIBUTE10
,      AEI_ATTRIBUTE11
,      AEI_ATTRIBUTE12
,      AEI_ATTRIBUTE13
,      AEI_ATTRIBUTE14
,      AEI_ATTRIBUTE15
,      AEI_ATTRIBUTE16
,      AEI_ATTRIBUTE17
,      AEI_ATTRIBUTE18
,      AEI_ATTRIBUTE19
,      AEI_ATTRIBUTE20
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      AEI_INFORMATION_CATEGORY
,      AEI_INFORMATION1
,      AEI_INFORMATION2
,      AEI_INFORMATION3
,      AEI_INFORMATION4
,      AEI_INFORMATION5
,      AEI_INFORMATION6
,      AEI_INFORMATION7
,      AEI_INFORMATION8
,      AEI_INFORMATION9
,      AEI_INFORMATION10
,      AEI_INFORMATION11
,      AEI_INFORMATION12
,      AEI_INFORMATION13
,      AEI_INFORMATION14
,      AEI_INFORMATION15
,      AEI_INFORMATION16
,      AEI_INFORMATION17
,      AEI_INFORMATION18
,      AEI_INFORMATION19
,      AEI_INFORMATION20
,      AEI_INFORMATION21
,      AEI_INFORMATION22
,      AEI_INFORMATION23
,      AEI_INFORMATION24
,      AEI_INFORMATION25
,      AEI_INFORMATION26
,      AEI_INFORMATION27
,      AEI_INFORMATION28
,      AEI_INFORMATION29
,      AEI_INFORMATION30
,      OBJECT_VERSION_NUMBER
,      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_ASSIGNMENT_EI_V;

Dependencies

[top of page]

APPS.GHR_MT_ASSIGNMENT_EI_V references the following:

APPS: GHR_INTERFACE

APPS.GHR_MT_ASSIGNMENT_EI_V is referenced by following:

APPS: GHR_MTO_INT - show dependent code; GHR_MT_INTERFACE_V