VIEW: APPS.IGR_I_A_LINES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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