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
, 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
, LINE.CATEGORY_ID PRODUCT_CATEGORY_ID
, DECODE(GREATEST(LENGTH(DENORM.CONCAT_CAT_PARENTAGE)
, 2000)
, 2000
, DENORM.CONCAT_CAT_PARENTAGE
, SUBSTR(DENORM.CONCAT_CAT_PARENTAGE
, LENGTH(DENORM.CONCAT_CAT_PARENTAGE)-1999
, 2000)) CONCATENATED_PRODUCT_CAT_DESC
, DENORM.CATEGORY_DESC PRODUCT_CATEGORY_DESC
, LINE.CATEGORY_SET_ID PRODUCT_CATEGORY_SET_ID
FROM IGR_I_A_LINES IPF
, ENI_PROD_DEN_HRCHY_PARENTS_V DENORM
, AS_SALES_LEAD_LINES LINE
, IGR_I_APPL EAP
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 DENORM.CATEGORY_ID = LINE.CATEGORY_ID