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_ITEM_DETLS_INFO_VL

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

View Text

SELECT IDI.INVENTORY_ITEM_ID
, IDI.TEMPLATE_BUSINESS
, IDI.TEMPLATE_CONSUMER
, IDI.MARKETING_TEXT_FILE
, IDT.MARKETING_TEXT
, IDI.SPECIAL_FLAG_BUSINESS
, IDI.SPECIAL_IMAGE_BUSINESS
, IDI.SPECIAL_TEXT_BUSINESS
, IDI.SPECIAL_THUMBNAIL_BUSINESS
, IDI.SPECIAL_START_DATE_BUSINESS
, IDI.SPECIAL_END_DATE_BUSINESS
, IDI.SPECIAL_FLAG_CONSUMER
, IDI.SPECIAL_IMAGE_CONSUMER
, IDI.SPECIAL_TEXT_CONSUMER
, IDI.SPECIAL_THUMBNAIL_CONSUMER
, IDI.SPECIAL_START_DATE_CONSUMER
, IDI.SPECIAL_END_DATE_CONSUMER
, IDI.IMAGE_FILE_1
, IDI.IMAGE_FILE_2
, IDI.IMAGE_FILE_3
, IDI.IMAGE_FILE_4
, IDI.IMAGE_FILE_5
, IDI.IMAGE_FILE_6
, IDI.IMAGE_FILE_7
, IDI.IMAGE_FILE_8
, IDI.IMAGE_FILE_9
, IDI.IMAGE_FILE_10
, IDI.IMAGE_FILE_11
, IDI.IMAGE_FILE_12
, IDI.IMAGE_FILE_13
, IDI.IMAGE_FILE_14
, IDI.IMAGE_FILE_15
FROM ICX_ITEM_DETLS_INFO IDI
, ICX_ITEM_DETLS_INFO_TL IDT
WHERE IDT.INVENTORY_ITEM_ID(+) = IDI.INVENTORY_ITEM_ID
AND IDT.LANGUAGE(+) = USERENV('LANG') UNION SELECT IDT.INVENTORY_ITEM_ID
, IDI.TEMPLATE_BUSINESS
, IDI.TEMPLATE_CONSUMER
, IDI.MARKETING_TEXT_FILE
, IDT.MARKETING_TEXT
, IDI.SPECIAL_FLAG_BUSINESS
, IDI.SPECIAL_IMAGE_BUSINESS
, IDI.SPECIAL_TEXT_BUSINESS
, IDI.SPECIAL_THUMBNAIL_BUSINESS
, IDI.SPECIAL_START_DATE_BUSINESS
, IDI.SPECIAL_END_DATE_BUSINESS
, IDI.SPECIAL_FLAG_CONSUMER
, IDI.SPECIAL_IMAGE_CONSUMER
, IDI.SPECIAL_TEXT_CONSUMER
, IDI.SPECIAL_THUMBNAIL_CONSUMER
, IDI.SPECIAL_START_DATE_CONSUMER
, IDI.SPECIAL_END_DATE_CONSUMER
, IDI.IMAGE_FILE_1
, IDI.IMAGE_FILE_2
, IDI.IMAGE_FILE_3
, IDI.IMAGE_FILE_4
, IDI.IMAGE_FILE_5
, IDI.IMAGE_FILE_6
, IDI.IMAGE_FILE_7
, IDI.IMAGE_FILE_8
, IDI.IMAGE_FILE_9
, IDI.IMAGE_FILE_10
, IDI.IMAGE_FILE_11
, IDI.IMAGE_FILE_12
, IDI.IMAGE_FILE_13
, IDI.IMAGE_FILE_14
, IDI.IMAGE_FILE_15
FROM ICX_ITEM_DETLS_INFO IDI
, ICX_ITEM_DETLS_INFO_TL IDT
WHERE IDT.INVENTORY_ITEM_ID = IDI.INVENTORY_ITEM_ID (+)
AND IDT.LANGUAGE = USERENV('LANG')

Columns

Name
INVENTORY_ITEM_ID
TEMPLATE_BUSINESS
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