1186: IF (NVL(l_old_catalog_id,-1) <> NVL(cr.item_catalog_group_id,-1) AND cr.item_catalog_group_id IS NOT NULL) THEN
1187: BEGIN
1188: /*Bug:3491746
1189: SELECT 'x' into temp
1190: FROM mtl_item_catalog_groups_b
1191: WHERE item_catalog_group_id = cr.item_catalog_group_id
1192: AND item_creation_allowed_flag = 'Y'
1193: AND item_catalog_group_id IN
1194: (SELECT ICG.item_catalog_group_id
1191: WHERE item_catalog_group_id = cr.item_catalog_group_id
1192: AND item_creation_allowed_flag = 'Y'
1193: AND item_catalog_group_id IN
1194: (SELECT ICG.item_catalog_group_id
1195: FROM mtl_item_catalog_groups_b ICG
1196: WHERE ICG.item_creation_allowed_flag = 'Y'
1197: AND ((ICG.inactive_date IS NULL) OR (TRUNC(ICG.inactive_date) > TRUNC(SYSDATE))));
1198: ELSE
1199: SELECT 'x' into temp
1196: WHERE ICG.item_creation_allowed_flag = 'Y'
1197: AND ((ICG.inactive_date IS NULL) OR (TRUNC(ICG.inactive_date) > TRUNC(SYSDATE))));
1198: ELSE
1199: SELECT 'x' into temp
1200: FROM mtl_item_catalog_groups_b
1201: WHERE item_catalog_group_id = cr.item_catalog_group_id
1202: AND item_creation_allowed_flag = 'Y'
1203: AND item_catalog_group_id IN
1204: (SELECT ICG.item_catalog_group_id
1201: WHERE item_catalog_group_id = cr.item_catalog_group_id
1202: AND item_creation_allowed_flag = 'Y'
1203: AND item_catalog_group_id IN
1204: (SELECT ICG.item_catalog_group_id
1205: FROM mtl_item_catalog_groups_b ICG
1206: WHERE ICG.item_creation_allowed_flag = 'Y'
1207: --Bug: 2805253 Removed NVL
1208: AND ((ICG.inactive_date IS NULL) OR (TRUNC(ICG.inactive_date) > TRUNC(SYSDATE)))
1209: CONNECT BY PRIOR ICG.item_catalog_group_id = ICG.parent_catalog_group_id
1210: START WITH ICG.item_catalog_group_id = l_old_catalog_id);
1211: END IF;
1212: */
1213: SELECT 'x' into temp
1214: FROM mtl_item_catalog_groups_b
1215: WHERE item_catalog_group_id = cr.item_catalog_group_id
1216: AND item_creation_allowed_flag = 'Y'
1217: AND (inactive_date IS NULL OR TRUNC(inactive_date) > TRUNC(SYSDATE));
1218: EXCEPTION