[Home] [Help]
View: OKL_AM_ITEM_CATEGORIES_UV
View Text
SELECT CG.DESCRIPTION DESCRIPTION
, CG.ITEM_CATALOG_GROUP_ID CATEGORY_ID
FROM MTL_ITEM_CATALOG_GROUPS_V CG
WHERE NVL (CG.START_DATE_ACTIVE
, SYSDATE - 1) <= SYSDATE
AND NVL (CG.END_DATE_ACTIVE
, SYSDATE + 1) >= SYSDATE
Columns
Name |
DESCRIPTION |
CATEGORY_ID |