eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: ICX_CATG_DETLS_INFO_VL

Product:	ICX - Oracle iProcurement
Description:	Category details translated view
Implementation/DBA Data:	APPS.ICX_CATG_DETLS_INFO_VL

View Text

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')

Columns

Name
CATEGORY_ID
TEMPLATE_BUSINESS
TEMPLATE_CONSUMER
DEFAULT_TEMPLATE_BUSINESS
DEFAULT_TEMPLATE_CONSUMER
MARKETING_TEXT_FILE
MARKETING_TEXT
SPECIAL_FLAG_BUSINESS
SPECIAL_IMAGE_BUSINESS
SPECIAL_TEXT_BUSINESS
SPECIAL_THUMBNAIL_BUSINESS
SPECIAL_START_DATE_BUSINESS
SPECIAL_END_DATE_BUSINESS
SPECIAL_FLAG_CONSUMER
SPECIAL_IMAGE_CONSUMER
SPECIAL_TEXT_CONSUMER
SPECIAL_THUMBNAIL_CONSUMER
SPECIAL_START_DATE_CONSUMER
SPECIAL_END_DATE_CONSUMER
IMAGE_FILE_1
IMAGE_FILE_2
IMAGE_FILE_3
IMAGE_FILE_4
IMAGE_FILE_5
IMAGE_FILE_6
IMAGE_FILE_7
IMAGE_FILE_8
IMAGE_FILE_9
IMAGE_FILE_10
IMAGE_FILE_11
IMAGE_FILE_12
IMAGE_FILE_13
IMAGE_FILE_14
IMAGE_FILE_15