APPS.GMIVDX dependencies on GMI_ITEM_CATEGORIES

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

316:
317: CURSOR Cur_gl_cls (p_item ic_item_mst.item_id%TYPE) IS
318: SELECT gic.item_id, gcs.opm_class, gic.category_id, kfv.CONCATENATED_SEGMENTS,
319: mcv.description
320: FROM mtl_categories_vl mcv, mtl_categories_b_kfv kfv, gmi_category_sets gcs, gmi_item_categories gic
321: WHERE gcs.category_set_id IS NOT NULL
322: AND gic.item_id = p_item
323: AND gcs.opm_class IN ('GL_BUSINESS_CLASS', 'GL_PRODUCT_LINE')
324: AND gcs.category_set_id = gic.category_set_id

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

327: ORDER BY gic.item_id, gcs.opm_class ;
328:
329: v_business_class_found BOOLEAN := FALSE;
330: v_product_line_found BOOLEAN := FALSE;
331: gl_business_class_cat_id gmi_item_categories.category_id%TYPE := NULL;
332: gl_product_line_cat_id gmi_item_categories.category_id%TYPE := NULL;
333: item_gl_class ic_item_mst.gl_class%TYPE;
334: --End Supriya Malluru Bug#4114621
335:

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

328:
329: v_business_class_found BOOLEAN := FALSE;
330: v_product_line_found BOOLEAN := FALSE;
331: gl_business_class_cat_id gmi_item_categories.category_id%TYPE := NULL;
332: gl_product_line_cat_id gmi_item_categories.category_id%TYPE := NULL;
333: item_gl_class ic_item_mst.gl_class%TYPE;
334: --End Supriya Malluru Bug#4114621
335:
336: BEGIN