Product: | IGS - Student System (Obsolete) |
---|---|
Description: | This view will be based on OMO public view AS_SALES_LEAD_LINES_V (From OMO Lead team, in discussion) and IGS_IN_INQUIRY_APPL_LINES junction table. We will only expose attributes in that table that OSS needs. |
Implementation/DBA Data: | Not implemented in this database |
SELECT IPF.ROWID ROW_ID
, IPF.SALES_LEAD_LINE_ID
, IPF.PERSON_ID
, IPF.ENQUIRY_APPL_NUMBER
, IES.INQ_ENTRY_STAT_ID
, LINE.INTEREST_TYPE_ID ENTRY_STATUS_ID
, LINE.INTEREST_TYPE ENTRY_STATUS
, LINE.INTEREST_TYPE_DESCRIPTION ENTRY_STATUS_DESC
, LINE.PRIMARY_INTEREST_CODE_ID INQ_PROG_CODE_ID
, LINE.PRIMARY_INTEREST_CODE INQ_PROG_CODE
, LINE.PRIMARY_INTEREST_DESCRIPTION INQ_PROG_CODE_DESC
, LINE.SECONDARY_INTEREST_CODE_ID INQ_USET_CODE_ID
, LINE.SECONDARY_INTEREST_CODE INQ_USET_CODE
, LINE.SECONDARY_INTEREST_DESCRIPTION INQ_USET_CODE_DESC
, IPF.PREFERENCE
, IPF.PROGRAM_APPLICATION_ID
, IPF.PROGRAM_ID
, IPF.PROGRAM_UPDATE_DATE
, IPF.REQUEST_ID
, LINE.CREATED_BY
, LINE.CREATION_DATE
, LINE.LAST_UPDATED_BY
, LINE.LAST_UPDATE_DATE
, LINE.LAST_UPDATE_LOGIN
, EAP.ENQUIRY_DT
, EAP.INQUIRY_METHOD_CODE
FROM IGS_RC_I_A_LINES IPF
, AS_SALES_LEAD_LINES_V LINE
, IGS_RC_I_APPL EAP
, IGS_RC_I_ENT_STATS IES
WHERE IPF.SALES_LEAD_LINE_ID = LINE.SALES_LEAD_LINE_ID
AND IPF.PERSON_ID = EAP.PERSON_ID
AND IPF.ENQUIRY_APPL_NUMBER = EAP.ENQUIRY_APPL_NUMBER
AND IES.INTEREST_TYPE_ID = LINE.INTEREST_TYPE_ID