Product: | ICX - Oracle iProcurement |
---|---|
Description: | Item details translated view |
Implementation/DBA Data: | APPS.ICX_ITEM_DETLS_INFO_VL |
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')