APPS.GMIVDX dependencies on GMI_ITEM_CATEGORIES

Line 313: FROM mtl_categories_vl mcv, mtl_categories_b_kfv kfv, gmi_category_sets gcs, gmi_item_categories gic

309:
310: CURSOR Cur_gl_cls (p_item ic_item_mst.item_id%TYPE) IS
311: SELECT gic.item_id, gcs.opm_class, gic.category_id, kfv.CONCATENATED_SEGMENTS,
312: mcv.description
313: FROM mtl_categories_vl mcv, mtl_categories_b_kfv kfv, gmi_category_sets gcs, gmi_item_categories gic
314: WHERE gcs.category_set_id IS NOT NULL
315: AND gic.item_id = p_item
316: AND gcs.opm_class IN ('GL_BUSINESS_CLASS', 'GL_PRODUCT_LINE')
317: AND gcs.category_set_id = gic.category_set_id

Line 324: gl_business_class_cat_id gmi_item_categories.category_id%TYPE := NULL;

320: ORDER BY gic.item_id, gcs.opm_class ;
321:
322: v_business_class_found BOOLEAN := FALSE;
323: v_product_line_found BOOLEAN := FALSE;
324: gl_business_class_cat_id gmi_item_categories.category_id%TYPE := NULL;
325: gl_product_line_cat_id gmi_item_categories.category_id%TYPE := NULL;
326: item_gl_class ic_item_mst.gl_class%TYPE;
327: --End Supriya Malluru Bug#4114621
328:

Line 325: gl_product_line_cat_id gmi_item_categories.category_id%TYPE := NULL;

321:
322: v_business_class_found BOOLEAN := FALSE;
323: v_product_line_found BOOLEAN := FALSE;
324: gl_business_class_cat_id gmi_item_categories.category_id%TYPE := NULL;
325: gl_product_line_cat_id gmi_item_categories.category_id%TYPE := NULL;
326: item_gl_class ic_item_mst.gl_class%TYPE;
327: --End Supriya Malluru Bug#4114621
328:
329: BEGIN