APPS.OZF_SD_REQUEST_PUB dependencies on MTL_CATEGORIES_V

Line 1055: FROM mtl_categories_v

1051: AND organization_id = p_org_id;
1052:
1053: CURSOR c_category_id(p_category_id IN NUMBER) IS
1054: SELECT category_id
1055: FROM mtl_categories_v
1056: WHERE category_id = p_category_id;
1057:
1058: CURSOR c_category_set_id(p_category_id IN NUMBER,p_category_set_id IN NUMBER)IS
1059: SELECT b.category_set_id

Line 1062: mtl_categories_v c

1058: CURSOR c_category_set_id(p_category_id IN NUMBER,p_category_set_id IN NUMBER)IS
1059: SELECT b.category_set_id
1060: FROM mtl_default_category_sets a ,
1061: mtl_category_sets_b b ,
1062: mtl_categories_v c
1063: WHERE a.functional_area_id in (7,11)
1064: AND a.category_set_id = b.category_set_id
1065: AND b.structure_id = c.structure_id
1066: AND c.category_id = p_category_id