Product: | ICX - Oracle iProcurement |
---|---|
Description: | Category attribute details view |
Implementation/DBA Data: | APPS.ICX_CATG_DETLS_INFO_V |
SELECT DISTINCT(IWC.CATEGORY_ID) CATEGORY_ID
, IWC.DESCRIPTION
, ICI.TEMPLATE_BUSINESS
, ICI.TEMPLATE_CONSUMER
, ICI.DEFAULT_TEMPLATE_CONSUMER
, ICI.DEFAULT_TEMPLATE_BUSINESS
, ICI.MARKETING_TEXT_FILE
, ICI.MARKETING_TEXT
, ICI.SPECIAL_FLAG_BUSINESS
, ICI.SPECIAL_IMAGE_BUSINESS
, ICI.SPECIAL_TEXT_BUSINESS
, ICI.SPECIAL_THUMBNAIL_BUSINESS
, ICI.SPECIAL_START_DATE_BUSINESS
, ICI.SPECIAL_END_DATE_BUSINESS
, ICI.SPECIAL_FLAG_CONSUMER
, ICI.SPECIAL_IMAGE_CONSUMER
, ICI.SPECIAL_TEXT_CONSUMER
, ICI.SPECIAL_THUMBNAIL_CONSUMER
, ICI.SPECIAL_START_DATE_CONSUMER
, ICI.SPECIAL_END_DATE_CONSUMER
, ICI.IMAGE_FILE_1
, ICI.IMAGE_FILE_2
, ICI.IMAGE_FILE_3
, ICI.IMAGE_FILE_4
, ICI.IMAGE_FILE_5
, ICI.IMAGE_FILE_6
, ICI.IMAGE_FILE_7
, ICI.IMAGE_FILE_8
, ICI.IMAGE_FILE_9
, ICI.IMAGE_FILE_10
, ICI.IMAGE_FILE_11
, ICI.IMAGE_FILE_12
, ICI.IMAGE_FILE_13
, ICI.IMAGE_FILE_14
, ICI.IMAGE_FILE_15
FROM ICX_WEBSTORE_CATEGORIES_V IWC
, ICX_CATG_DETLS_INFO_VL ICI
WHERE IWC.CATEGORY_ID = ICI.CATEGORY_ID (+)