APPS.JAI_OM_UTILS_PKG dependencies on MTL_ITEM_CATEGORIES_V

Line 301: mtl_item_categories_v d

297: AND NVL( b.end_date_active, SYSDATE)
298: AND EXISTS ( SELECT
299: 'x'
300: FROM
301: mtl_item_categories_v d
302: WHERE d.category_set_name = lv_category_set_name
303: AND d.inventory_item_id = pn_inventory_item_id
304: AND c.product_attr_value = TO_CHAR(d.category_id)
305: );

Line 336: mtl_item_categories_v d

332: AND NVL(primary_uom_flag,'N') ='Y'
333: AND EXISTS ( SELECT
334: 'x'
335: FROM
336: mtl_item_categories_v d
337: WHERE d.category_set_name = lv_category_set_name
338: AND d.inventory_item_id = pn_inventory_item_id
339: AND c.product_attr_value = TO_CHAR(d.category_id)
340: );

Line 370: mtl_item_categories_v d

366: AND TRUNC(NVL(b.end_date_active,SYSDATE)) >= TRUNC(pd_ordered_date)
367: AND EXISTS ( SELECT
368: 'x'
369: FROM
370: mtl_item_categories_v d
371: WHERE d.category_set_name = lv_category_set_name
372: AND d.inventory_item_id = pn_inventory_item_id
373: AND c.product_attr_value = TO_CHAR(d.category_id)
374: );