DBA Data[Home] [Help]

APPS.GMIVDX dependencies on MTL_CATEGORIES_VL

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