DBA Data[Home] [Help]

APPS.ENI_DENORM_HRCHY dependencies on MTL_DEFAULT_CATEGORY_SETS

Line 14: FROM MTL_DEFAULT_CATEGORY_SETS

10: FUNCTION GET_CATEGORY_SET_ID RETURN NUMBER IS
11: l_catset_id NUMBER;
12: BEGIN
13: SELECT CATEGORY_SET_ID INTO l_catset_id
14: FROM MTL_DEFAULT_CATEGORY_SETS
15: WHERE FUNCTIONAL_AREA_ID = g_func_area_id;
16:
17: RETURN l_catset_id;
18: EXCEPTION

Line 1860: FROM mtl_default_category_sets mdcs

1856:
1857: BEGIN
1858: SELECT csvl.category_set_name
1859: INTO l_product_catalog
1860: FROM mtl_default_category_sets mdcs
1861: ,mtl_category_sets_vl csvl
1862: WHERE csvl.category_set_id = mdcs.category_set_id AND mdcs.functional_area_id=11;
1863: EXCEPTION WHEN OTHERS THEN
1864: FND_FILE.PUT_LINE(FND_FILE.LOG,'Exception while searching for functional area 11');