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 1889: FROM mtl_default_category_sets mdcs

1885:
1886: BEGIN
1887: SELECT csvl.category_set_name
1888: INTO l_product_catalog
1889: FROM mtl_default_category_sets mdcs
1890: ,mtl_category_sets_vl csvl
1891: WHERE csvl.category_set_id = mdcs.category_set_id AND mdcs.functional_area_id=11;
1892: EXCEPTION WHEN OTHERS THEN
1893: FND_FILE.PUT_LINE(FND_FILE.LOG,'Exception while searching for functional area 11');