DBA Data[Home] [Help]

APPS.GMIVDX dependencies on MTL_CATEGORIES_B_KFV

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