570: AND NVL( b.end_date_active, SYSDATE)
571: AND EXISTS ( SELECT
572: 'x'
573: FROM
574: mtl_item_categories_v d
575: WHERE d.category_set_name = lv_category_set_name
576: AND d.inventory_item_id = pn_inventory_item_id
577: AND c.product_attr_value = TO_CHAR(d.category_id)
578: );
1022: AND NVL( end_date_active, SYSDATE +1 )>= SYSDATE
1023: AND EXISTS ( SELECT
1024: 'x'
1025: FROM
1026: mtl_item_categories_v d
1027: WHERE d.category_set_name = lv_category_set_name
1028: AND d.inventory_item_id = pn_inventory_item_id
1029: AND c.product_attr_value = TO_CHAR(d.category_id)
1030: );