APPS.OZF_SD_REQUEST_PUB dependencies on MTL_CATEGORIES_V

Line 1255: FROM mtl_categories_v

1251: AND organization_id = p_org_id;
1252:
1253: CURSOR c_category_id(p_category_id IN NUMBER) IS
1254: SELECT category_id
1255: FROM mtl_categories_v
1256: WHERE category_id = p_category_id;
1257:
1258: CURSOR c_category_set_id(p_category_id IN NUMBER,p_category_set_id IN NUMBER)IS
1259: SELECT b.category_set_id

Line 1262: mtl_categories_v c

1258: CURSOR c_category_set_id(p_category_id IN NUMBER,p_category_set_id IN NUMBER)IS
1259: SELECT b.category_set_id
1260: FROM mtl_default_category_sets a ,
1261: mtl_category_sets_b b ,
1262: mtl_categories_v c
1263: WHERE a.functional_area_id in (7,11)
1264: AND a.category_set_id = b.category_set_id
1265: AND b.structure_id = c.structure_id
1266: AND c.category_id = p_category_id

Line 1273: mtl_categories_v c

1269: CURSOR c_get_category_set_id(p_category_id IN NUMBER)IS
1270: SELECT b.category_set_id
1271: FROM mtl_default_category_sets a ,
1272: mtl_category_sets_b b ,
1273: mtl_categories_v c
1274: WHERE a.functional_area_id in (7,11)
1275: AND a.category_set_id = b.category_set_id
1276: AND b.structure_id = c.structure_id
1277: AND c.category_id = p_category_id;