APPS.INV_GMI_MIGRATION dependencies on MTL_DEFAULT_CATEGORY_SETS

Line 508: FROM mtl_default_category_sets s,

504: FOR c in c_opm_category_sets LOOP
505: BEGIN
506: SELECT functional_area_id, category_set_id
507: INTO l_functional_area_id, l_category_set_id
508: FROM mtl_default_category_sets s,
509: mfg_lookups l
510: WHERE
511: l.lookup_type = 'MTL_FUNCTIONAL_AREAS' and
512: l.meaning = 'Process '|| decode (c.user_opm_class, 'General Ledger Class',

Line 537: UPDATE mtl_default_category_sets

533: END IF;
534:
535: -- Update discrete functional area with OPM category set id for convergence
536: -- functional areas
537: UPDATE mtl_default_category_sets
538: SET category_set_id = NVL(c.category_set_id, -1)
539: WHERE
540: functional_area_id = l_functional_area_id and
541: category_set_id = -1;