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.

[Home] [Help]

View: IGR_I_APPL

Product:	IGS - Student System (Obsolete)
Description:	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
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT A.ROWID ROW_ID
, A.SALES_LEAD_ID
, A.PERSON_ID PERSON_ID
, A.ENQUIRY_APPL_NUMBER ENQUIRY_APPL_NUMBER
, A.ACAD_CAL_TYPE ACAD_CAL_TYPE
, A.ACAD_CI_SEQUENCE_NUMBER ACAD_CI_SEQUENCE_NUMBER
, A.ADM_CAL_TYPE ADM_CAL_TYPE
, A.ADM_CI_SEQUENCE_NUMBER ADM_CI_SEQUENCE_NUMBER
, A.ENQUIRY_DT ENQUIRY_DT
, LEAD.VEHICLE_RESPONSE_CODE INQUIRY_METHOD_CODE
, LEAD.LEAD_STATUS ENQUIRY_STATUS
, LEAD.STATUS_CODE S_ENQUIRY_STATUS
, LEAD.STATUS_ENABLED_FLAG ENABLED_FLAG
, LEAD.VEH_RESP_CODE_DESCRIPTION DSP_DESCRIPTION
, LEAD.VEH_RESP_CODE_MEANING INQUIRY_METHOD
, LEAD.VEH_RESP_CODE_ENABLED_FLAG DSP_CLOSED_IND
, A.REGISTERING_PERSON_ID REGISTERING_PERSON_ID
, A.OVERRIDE_PROCESS_IND OVERRIDE_PROCESS_IND
, A.INDICATED_MAILING_DT INDICATED_MAILING_DT
, A.LAST_PROCESS_DT LAST_PROCESS_DT
, A.COMMENTS COMMENTS
, A.INQ_ENTRY_LEVEL_ID
, A.EDU_GOAL_ID
, A.PARTY_ID
, A.HOW_KNOWUS_ID
, A.WHO_INFLUENCED_ID
, A.ATTRIBUTE_CATEGORY
, A.ATTRIBUTE1
, A.ATTRIBUTE2
, A.ATTRIBUTE3
, A.ATTRIBUTE4
, A.ATTRIBUTE5
, A.ATTRIBUTE6
, A.ATTRIBUTE7
, A.ATTRIBUTE8
, A.ATTRIBUTE9
, A.ATTRIBUTE10
, A.ATTRIBUTE11
, A.ATTRIBUTE12
, A.ATTRIBUTE13
, A.ATTRIBUTE14
, A.ATTRIBUTE15
, A.ATTRIBUTE16
, A.ATTRIBUTE17
, A.ATTRIBUTE18
, A.ATTRIBUTE19
, A.ATTRIBUTE20
, A.ORG_ID ORG_ID
, LEAD.CREATED_BY CREATED_BY
, LEAD.CREATION_DATE CREATION_DATE
, LEAD.LAST_UPDATED_BY LAST_UPDATED_BY
, LEAD.LAST_UPDATE_DATE LAST_UPDATE_DATE
, LEAD.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, A.REQUEST_ID REQUEST_ID
, A.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, A.PROGRAM_ID PROGRAM_ID
, A.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, LEAD.SOURCE_PROMOTION_ID SOURCE_PROMOTION_ID
, A.PKG_REDUCT_IND PKG_REDUCT_IND
FROM IGR_I_APPL_ALL A
, AS_SALES_LEADS_V LEAD
WHERE A.SALES_LEAD_ID = LEAD.SALES_LEAD_ID
AND NVL(A.ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)

Columns

Name
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