[Home] [Help]
View: IBE_DSP_TPL_CTG_V
View Text
SELECT JDTC.TPL_CTG_ID
, JDTC.ITEM_ID
, JAIV.ITEM_NAME
, JAIV.DESCRIPTION ITEM_DESCRIPTION
, JAIV.FILE_NAME
, JDTC.CATEGORY_ID
, MCV.CATEGORY_CONCAT_SEGS CATEGORY_NAME
, MCV.DESCRIPTION CATEGORY_DESCRIPTION
FROM IBE_DSP_TPL_CTG JDTC
, IBE_DSP_AMV_ITEMS_V JAIV
, MTL_CATEGORIES_V MCV
WHERE MCV.CATEGORY_ID = JDTC.CATEGORY_ID
AND JAIV.ITEM_ID = JDTC.ITEM_ID WITH READ ONLY
Columns
Name |
TPL_CTG_ID |
ITEM_ID |
ITEM_NAME |
ITEM_DESCRIPTION |
FILE_NAME |
CATEGORY_ID |
CATEGORY_NAME |
CATEGORY_DESCRIPTION |