[Home] [Help]
VIEW: APPS.OKL_AM_ITEM_CATEGORIES_UV
Source
View Text - Preformatted
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
View Text - HTML Formatted
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