VIEW: APPS.ICX_ITEM_DETLS_INFO_VL

Source

View Text - Preformatted

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

View Text - HTML Formatted

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