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.IGR_I_APPL_V

Object Details

Object Name:	IGR_I_APPL_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGR_I_APPL_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
ROW_ID	ROWID	(10)		Row ID
SALES_LEAD_ID	NUMBER	(15)	Yes	Sales Lead ID
PERSON_ID	NUMBER	(15)	Yes	Person ID
PERSON_NUMBER	VARCHAR2	(30)		Unique identification number for this party
ENQUIRY_APPL_NUMBER	NUMBER	(15)	Yes	Inquiry Application Number
ACAD_CAL_TYPE	VARCHAR2	(10)	Yes	Academic Calendar Type
ACAD_CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	A unique number that identifies the academic calendar instance that the inquiry application refers to
ADM_CAL_TYPE	VARCHAR2	(10)		Admission Calendar Type
ADM_CI_SEQUENCE_NUMBER	NUMBER	(6)		A unique number that identifies the admission calendar instance that the inquiry application refers to
ENQUIRY_STATUS	VARCHAR2	(240)		Inquiry Status
S_ENQUIRY_STATUS	VARCHAR2	(30)	Yes	System Inquiry Status
MEANING	VARCHAR2	(240)		Inquiry Status Meaning
ENABLED_FLAG	VARCHAR2	(1)	Yes	Enabled Flag
DSP_DESCRIPTION	VARCHAR2	(240)		Inquiry Method Description
INQUIRY_METHOD	VARCHAR2	(80)		Inquiry Method
DSP_CLOSED_IND	VARCHAR2	(1)		Closed Indicator
ENQUIRY_DT	DATE		Yes	Inquiry Date
INQUIRY_METHOD_CODE	VARCHAR2	(30)		Inquiry Method Code
INQ_ENTRY_LEVEL_ID	NUMBER	(15)		Inquiry Entry Level ID
INQ_ENTRY_LEVEL	VARCHAR2	(30)		Inquiry entry level
INQ_ENTRY_LEVEL_DESCRIPTION	VARCHAR2	(240)		Inquiry Entry Level description
EDU_GOAL_ID	NUMBER	(15)		Educational Goal ID
EDU_GOAL_NAME	VARCHAR2	(10)		Educational Goal Name
EDU_GOAL_DESCRIPTION	VARCHAR2	(30)		Educational Goal description
ORG_UNIT_ID	VARCHAR2	(0)		Obsolete
ORG_UNIT_CD	VARCHAR2	(30)		Organization Unit Code
ORG_UNIT_DESCRIPTION	VARCHAR2	(60)		Name of the Organization Unit
HOW_KNOWUS_ID	NUMBER	(15)		How Know Us ID
HOW_KNOWUS_NAME	VARCHAR2	(10)		How Know Us Name
HOW_KNOWUS_DESC	VARCHAR2	(30)		How Know Us Description
WHO_INFLUENCED_ID	NUMBER	(15)		Who Influenced ID
WHO_INFLUENCED_NAME	VARCHAR2	(10)		Name of the person Who Influenced
WHO_INFLUENCED_DESC	VARCHAR2	(30)		Description of the person Who Influenced
REGISTERING_PERSON_ID	NUMBER	(15)		Registering Person ID
DSP_PREFERRED_NAME	VARCHAR2	(391)		Preferred Name
OVERRIDE_PROCESS_IND	VARCHAR2	(1)	Yes	Override Process Indicator
INDICATED_MAILING_DT	DATE			Indicated Mailing Date
LAST_PROCESS_DT	DATE			Last Process Date
COMMENTS	VARCHAR2	(2000)		Comments
REQUEST_ID	NUMBER	(15)		Request identifier of last concurrent program to update this record.
PROGRAM_APPLICATION_ID	NUMBER	(15)		Application identifier of last concurrent program to update this record.
PROGRAM_ID	NUMBER	(15)		Program identifier of last concurrent program to update this record.
PROGRAM_UPDATE_DATE	DATE			Last update date of this record by a concurrent program.
CREATED_BY	NUMBER		Yes	Standard WHO Column
CREATION_DATE	DATE		Yes	Standard WHO Column
LAST_UPDATED_BY	NUMBER		Yes	Standard WHO Column
LAST_UPDATE_DATE	DATE		Yes	Standard WHO Column
LAST_UPDATE_LOGIN	NUMBER			Standard WHO Column
PREFERRED_GIVEN_NAME	VARCHAR2	(240)		Preferred Given Name
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Attribute Category For Descriptive Flex field
ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flex Field Column
ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flex Field Column
ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flex Field Column
ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flex Field Column
ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flex Field Column
ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flex Field Column
ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flex Field Column
ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flex Field Column
ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flex Field Column
ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flex Field Column
ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flex Field Column
ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flex Field Column
ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flex Field Column
ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flex Field Column
ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flex Field Column
ATTRIBUTE16	VARCHAR2	(150)		Descriptive Flex Field Column
ATTRIBUTE17	VARCHAR2	(150)		Descriptive Flex Field Column
ATTRIBUTE18	VARCHAR2	(150)		Descriptive Flex Field Column
ATTRIBUTE19	VARCHAR2	(150)		Descriptive Flex Field Column
ATTRIBUTE20	VARCHAR2	(150)		Descriptive Flex Field Column
ADM_ALTERNATE_CODE	VARCHAR2	(10)		Admission Alternate Code
SCHOOL_APPLYING_TO	VARCHAR2	(30)		School Applying to
SOURCE_PROMOTION_ID	NUMBER			Storing the identifier for OMO campaigns or events
SOURCE_PROMOTION_CODE	VARCHAR2	(30)		Storing the code for OMO campaigns or events
SOURCE_PROMOTION_NAME	VARCHAR2	(2000)		Storing the name for OMO campaigns or events
SOURCE_PROMOTION_TYPE	VARCHAR2	(80)		Storing the type for OMO campaigns or events
SCH_APL_TO_ID	NUMBER	(15)		School Applying To ID
PKG_REDUCT_IND	VARCHAR2	(1)		Package Reduction Indicator

Query Text

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


SELECT ROW_ID
,      SALES_LEAD_ID
,      PERSON_ID
,      PERSON_NUMBER
,      ENQUIRY_APPL_NUMBER
,      ACAD_CAL_TYPE
,      ACAD_CI_SEQUENCE_NUMBER
,      ADM_CAL_TYPE
,      ADM_CI_SEQUENCE_NUMBER
,      ENQUIRY_STATUS
,      S_ENQUIRY_STATUS
,      MEANING
,      ENABLED_FLAG
,      DSP_DESCRIPTION
,      INQUIRY_METHOD
,      DSP_CLOSED_IND
,      ENQUIRY_DT
,      INQUIRY_METHOD_CODE
,      INQ_ENTRY_LEVEL_ID
,      INQ_ENTRY_LEVEL
,      INQ_ENTRY_LEVEL_DESCRIPTION
,      EDU_GOAL_ID
,      EDU_GOAL_NAME
,      EDU_GOAL_DESCRIPTION
,      ORG_UNIT_ID
,      ORG_UNIT_CD
,      ORG_UNIT_DESCRIPTION
,      HOW_KNOWUS_ID
,      HOW_KNOWUS_NAME
,      HOW_KNOWUS_DESC
,      WHO_INFLUENCED_ID
,      WHO_INFLUENCED_NAME
,      WHO_INFLUENCED_DESC
,      REGISTERING_PERSON_ID
,      DSP_PREFERRED_NAME
,      OVERRIDE_PROCESS_IND
,      INDICATED_MAILING_DT
,      LAST_PROCESS_DT
,      COMMENTS
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PREFERRED_GIVEN_NAME
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ADM_ALTERNATE_CODE
,      SCHOOL_APPLYING_TO
,      SOURCE_PROMOTION_ID
,      SOURCE_PROMOTION_CODE
,      SOURCE_PROMOTION_NAME
,      SOURCE_PROMOTION_TYPE
,      SCH_APL_TO_ID
,      PKG_REDUCT_IND
FROM APPS.IGR_I_APPL_V;

Dependencies

[top of page]

APPS.IGR_I_APPL_V references the following:

APPS: AMS_LOOKUPS; AMS_P_SOURCE_CODES_V; AS_STATUSES_VL; HZ_PARTIES; IGR_I_APPL; IGR_I_ENTRY_LVLS; IGS_AD_CODE_CLASSES; IGS_AD_SCHL_APLY_TO; IGS_CA_INST

APPS.IGR_I_APPL_V is referenced by following:

APPS: IGR_GEN_001 - show dependent code; IGR_IMP_003 - show dependent code; IGR_I_A_PKGITM_PKG - show dependent code