VIEW: APPS.ICX_CATG_DETLS_INFO_VL

Source

View Text - Preformatted

SELECT CDI.CATEGORY_ID , CDI.TEMPLATE_BUSINESS , CDI.TEMPLATE_CONSUMER , CDI.DEFAULT_TEMPLATE_BUSINESS , CDI.DEFAULT_TEMPLATE_CONSUMER , CDI.MARKETING_TEXT_FILE , CDT.MARKETING_TEXT , CDI.SPECIAL_FLAG_BUSINESS , CDI.SPECIAL_IMAGE_BUSINESS , CDI.SPECIAL_TEXT_BUSINESS , CDI.SPECIAL_THUMBNAIL_BUSINESS , CDI.SPECIAL_START_DATE_BUSINESS , CDI.SPECIAL_END_DATE_BUSINESS , CDI.SPECIAL_FLAG_CONSUMER , CDI.SPECIAL_IMAGE_CONSUMER , CDI.SPECIAL_TEXT_CONSUMER , CDI.SPECIAL_THUMBNAIL_CONSUMER , CDI.SPECIAL_START_DATE_CONSUMER , CDI.SPECIAL_END_DATE_CONSUMER , CDI.IMAGE_FILE_1 , CDI.IMAGE_FILE_2 , CDI.IMAGE_FILE_3 , CDI.IMAGE_FILE_4 , CDI.IMAGE_FILE_5 , CDI.IMAGE_FILE_6 , CDI.IMAGE_FILE_7 , CDI.IMAGE_FILE_8 , CDI.IMAGE_FILE_9 , CDI.IMAGE_FILE_10 , CDI.IMAGE_FILE_11 , CDI.IMAGE_FILE_12 , CDI.IMAGE_FILE_13 , CDI.IMAGE_FILE_14 , CDI.IMAGE_FILE_15 FROM ICX_CATG_DETLS_INFO CDI, ICX_CATG_DETLS_INFO_TL CDT WHERE CDT.CATEGORY_ID(+) = CDI.CATEGORY_ID AND CDT.LANGUAGE(+) = USERENV('LANG') UNION SELECT CDT.CATEGORY_ID , CDI.TEMPLATE_BUSINESS , CDI.TEMPLATE_CONSUMER , CDI.DEFAULT_TEMPLATE_BUSINESS , CDI.DEFAULT_TEMPLATE_CONSUMER , CDI.MARKETING_TEXT_FILE , CDT.MARKETING_TEXT , CDI.SPECIAL_FLAG_BUSINESS , CDI.SPECIAL_IMAGE_BUSINESS , CDI.SPECIAL_TEXT_BUSINESS , CDI.SPECIAL_THUMBNAIL_BUSINESS , CDI.SPECIAL_START_DATE_BUSINESS , CDI.SPECIAL_END_DATE_BUSINESS , CDI.SPECIAL_FLAG_CONSUMER , CDI.SPECIAL_IMAGE_CONSUMER , CDI.SPECIAL_TEXT_CONSUMER , CDI.SPECIAL_THUMBNAIL_CONSUMER , CDI.SPECIAL_START_DATE_CONSUMER , CDI.SPECIAL_END_DATE_CONSUMER , CDI.IMAGE_FILE_1 , CDI.IMAGE_FILE_2 , CDI.IMAGE_FILE_3 , CDI.IMAGE_FILE_4 , CDI.IMAGE_FILE_5 , CDI.IMAGE_FILE_6 , CDI.IMAGE_FILE_7 , CDI.IMAGE_FILE_8 , CDI.IMAGE_FILE_9 , CDI.IMAGE_FILE_10 , CDI.IMAGE_FILE_11 , CDI.IMAGE_FILE_12 , CDI.IMAGE_FILE_13 , CDI.IMAGE_FILE_14 , CDI.IMAGE_FILE_15 FROM ICX_CATG_DETLS_INFO CDI, ICX_CATG_DETLS_INFO_TL CDT WHERE CDT.CATEGORY_ID = CDI.CATEGORY_ID (+) AND CDT.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT CDI.CATEGORY_ID
, CDI.TEMPLATE_BUSINESS
, CDI.TEMPLATE_CONSUMER
, CDI.DEFAULT_TEMPLATE_BUSINESS
, CDI.DEFAULT_TEMPLATE_CONSUMER
, CDI.MARKETING_TEXT_FILE
, CDT.MARKETING_TEXT
, CDI.SPECIAL_FLAG_BUSINESS
, CDI.SPECIAL_IMAGE_BUSINESS
, CDI.SPECIAL_TEXT_BUSINESS
, CDI.SPECIAL_THUMBNAIL_BUSINESS
, CDI.SPECIAL_START_DATE_BUSINESS
, CDI.SPECIAL_END_DATE_BUSINESS
, CDI.SPECIAL_FLAG_CONSUMER
, CDI.SPECIAL_IMAGE_CONSUMER
, CDI.SPECIAL_TEXT_CONSUMER
, CDI.SPECIAL_THUMBNAIL_CONSUMER
, CDI.SPECIAL_START_DATE_CONSUMER
, CDI.SPECIAL_END_DATE_CONSUMER
, CDI.IMAGE_FILE_1
, CDI.IMAGE_FILE_2
, CDI.IMAGE_FILE_3
, CDI.IMAGE_FILE_4
, CDI.IMAGE_FILE_5
, CDI.IMAGE_FILE_6
, CDI.IMAGE_FILE_7
, CDI.IMAGE_FILE_8
, CDI.IMAGE_FILE_9
, CDI.IMAGE_FILE_10
, CDI.IMAGE_FILE_11
, CDI.IMAGE_FILE_12
, CDI.IMAGE_FILE_13
, CDI.IMAGE_FILE_14
, CDI.IMAGE_FILE_15
FROM ICX_CATG_DETLS_INFO CDI
, ICX_CATG_DETLS_INFO_TL CDT
WHERE CDT.CATEGORY_ID(+) = CDI.CATEGORY_ID
AND CDT.LANGUAGE(+) = USERENV('LANG') UNION SELECT CDT.CATEGORY_ID
, CDI.TEMPLATE_BUSINESS
, CDI.TEMPLATE_CONSUMER
, CDI.DEFAULT_TEMPLATE_BUSINESS
, CDI.DEFAULT_TEMPLATE_CONSUMER
, CDI.MARKETING_TEXT_FILE
, CDT.MARKETING_TEXT
, CDI.SPECIAL_FLAG_BUSINESS
, CDI.SPECIAL_IMAGE_BUSINESS
, CDI.SPECIAL_TEXT_BUSINESS
, CDI.SPECIAL_THUMBNAIL_BUSINESS
, CDI.SPECIAL_START_DATE_BUSINESS
, CDI.SPECIAL_END_DATE_BUSINESS
, CDI.SPECIAL_FLAG_CONSUMER
, CDI.SPECIAL_IMAGE_CONSUMER
, CDI.SPECIAL_TEXT_CONSUMER
, CDI.SPECIAL_THUMBNAIL_CONSUMER
, CDI.SPECIAL_START_DATE_CONSUMER
, CDI.SPECIAL_END_DATE_CONSUMER
, CDI.IMAGE_FILE_1
, CDI.IMAGE_FILE_2
, CDI.IMAGE_FILE_3
, CDI.IMAGE_FILE_4
, CDI.IMAGE_FILE_5
, CDI.IMAGE_FILE_6
, CDI.IMAGE_FILE_7
, CDI.IMAGE_FILE_8
, CDI.IMAGE_FILE_9
, CDI.IMAGE_FILE_10
, CDI.IMAGE_FILE_11
, CDI.IMAGE_FILE_12
, CDI.IMAGE_FILE_13
, CDI.IMAGE_FILE_14
, CDI.IMAGE_FILE_15
FROM ICX_CATG_DETLS_INFO CDI
, ICX_CATG_DETLS_INFO_TL CDT
WHERE CDT.CATEGORY_ID = CDI.CATEGORY_ID (+)
AND CDT.LANGUAGE = USERENV('LANG')