APPS.INV_GMI_MIGRATION dependencies on MTL_DEFAULT_CATEGORY_SETS

Line 469: FROM mtl_default_category_sets s,

465: FOR c in c_opm_category_sets LOOP
466: BEGIN
467: SELECT functional_area_id, category_set_id
468: INTO l_functional_area_id, l_category_set_id
469: FROM mtl_default_category_sets s,
470: mfg_lookups l
471: WHERE
472: l.lookup_type = 'MTL_FUNCTIONAL_AREAS' and
473: l.meaning = 'Process '|| decode (c.user_opm_class, 'General Ledger Class',

Line 498: UPDATE mtl_default_category_sets

494: END IF;
495:
496: -- Update discrete functional area with OPM category set id for convergence
497: -- functional areas
498: UPDATE mtl_default_category_sets
499: SET category_set_id = NVL(c.category_set_id, -1)
500: WHERE
501: functional_area_id = l_functional_area_id and
502: category_set_id = -1;