SELECT UNIQUE sr_instance_id,
sr_category_id,
category_name,
description,
category_set_id
FROM msc_item_categories
WHERE enabled_flag ='Y'
AND NVL(start_date_active, sysdate)<=sysdate
AND NVL(end_date_active, sysdate) >=sysdate
SELECT UNIQUE SR_INSTANCE_ID
,
SR_CATEGORY_ID
,
CATEGORY_NAME
,
DESCRIPTION
,
CATEGORY_SET_ID
FROM MSC_ITEM_CATEGORIES
WHERE ENABLED_FLAG ='Y'
AND NVL(START_DATE_ACTIVE
, SYSDATE)<=SYSDATE
AND NVL(END_DATE_ACTIVE
, SYSDATE) >=SYSDATE
|
|
|