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

Object Details

Object Name:	IGR_I_APPL
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGR_I_APPL
Subobject Name:
Status:	VALID

View Type

A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.

This view is based on OMO public view AS_SALES_LEADS_V and IGR_I_APPL_ALL junction table. Attributes only that are needed by OSS are exposed

[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
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_DT	DATE		Yes	Inquiry Date
INQUIRY_METHOD_CODE	VARCHAR2	(30)		Inquiry Method Code
ENQUIRY_STATUS	VARCHAR2	(240)		Inquiry Status
S_ENQUIRY_STATUS	VARCHAR2	(30)	Yes	System Inquiry Status
ENABLED_FLAG	VARCHAR2	(1)	Yes	Enabled Flag
DSP_DESCRIPTION	VARCHAR2	(240)		Inquiry Method Code Description
INQUIRY_METHOD	VARCHAR2	(80)		Inquiry Method
DSP_CLOSED_IND	VARCHAR2	(1)		Closed Indicator
REGISTERING_PERSON_ID	NUMBER	(15)		Registering Person Identifier
OVERRIDE_PROCESS_IND	VARCHAR2	(1)	Yes	Override Process Indicator
INDICATED_MAILING_DT	DATE			Indicated Mailing Date
LAST_PROCESS_DT	DATE			Last Processing Date
COMMENTS	VARCHAR2	(2000)		Comments
INQ_ENTRY_LEVEL_ID	NUMBER	(15)		Inquiry Entry Level ID
EDU_GOAL_ID	NUMBER	(15)		Educational Goal ID
PARTY_ID	NUMBER	(15)		Party ID
HOW_KNOWUS_ID	NUMBER	(15)		How Know Us ID
WHO_INFLUENCED_ID	NUMBER	(15)		Who Influenced ID
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
ORG_ID	NUMBER	(15)		Organization ID
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
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.
SOURCE_PROMOTION_ID	NUMBER			Storing the identifier for OMO campaigns or events
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
,      ENQUIRY_APPL_NUMBER
,      ACAD_CAL_TYPE
,      ACAD_CI_SEQUENCE_NUMBER
,      ADM_CAL_TYPE
,      ADM_CI_SEQUENCE_NUMBER
,      ENQUIRY_DT
,      INQUIRY_METHOD_CODE
,      ENQUIRY_STATUS
,      S_ENQUIRY_STATUS
,      ENABLED_FLAG
,      DSP_DESCRIPTION
,      INQUIRY_METHOD
,      DSP_CLOSED_IND
,      REGISTERING_PERSON_ID
,      OVERRIDE_PROCESS_IND
,      INDICATED_MAILING_DT
,      LAST_PROCESS_DT
,      COMMENTS
,      INQ_ENTRY_LEVEL_ID
,      EDU_GOAL_ID
,      PARTY_ID
,      HOW_KNOWUS_ID
,      WHO_INFLUENCED_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ORG_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      SOURCE_PROMOTION_ID
,      PKG_REDUCT_IND
FROM APPS.IGR_I_APPL;

Dependencies

[top of page]

APPS.IGR_I_APPL references the following:

APPS: AS_SALES_LEADS_V; IGR_I_APPL_ALL

APPS.IGR_I_APPL is referenced by following:

APPS: IGR_GEN_001 - show dependent code; IGR_IMP_003 - show dependent code; IGR_I_APPL_V; IGR_I_A_CHAR_TYP_V; IGR_I_A_LINES_V; IGR_VAL_EAP - show dependent code