APPS.CST_MGD_MSTR_BOOK_RPT dependencies on MTL_CATEGORY_SETS

Line 656: FROM mtl_category_sets

652: IF p_category_set_id_from IS NOT NULL THEN
653: BEGIN
654: SELECT category_set_name
655: INTO gc_category_set_name_1
656: FROM mtl_category_sets
657: WHERE category_set_id = p_category_set_id_from; -- Changed by ppandit P_CATEGORY_SET_ID to P_CATEGORY_SET_ID_FROM
658: EXCEPTION
659: WHEN NO_DATA_FOUND THEN
660: gc_category_set_name_1 := NULL;

Line 668: FROM mtl_category_sets

664: IF p_category_set_id_to IS NOT NULL THEN -- Added by ppandit
665: BEGIN
666: SELECT category_set_name
667: INTO gc_category_set_name_2
668: FROM mtl_category_sets
669: WHERE category_set_id = p_category_set_id_to;
670: EXCEPTION
671: WHEN NO_DATA_FOUND THEN
672: gc_category_set_name_2 := NULL;

Line 1226: FROM mtl_category_sets MCS

1222: ln_cat_struct NUMBER;
1223: BEGIN
1224: SELECT MCS.structure_id
1225: INTO ln_cat_struct
1226: FROM mtl_category_sets MCS
1227: WHERE MCS.category_set_id = p_category_set_id;
1228:
1229: RETURN (ln_cat_struct);
1230: EXCEPTION

Line 2645: FROM mtl_category_sets

2641:
2642: CURSOR lcu_cat_range (p_cat_set_id In NUMBER)
2643: IS
2644: SELECT category_set_name
2645: FROM mtl_category_sets
2646: WHERE category_set_id = p_cat_set_id;
2647:
2648: lc_cat_set_high VARCHAR2 (30);
2649: lc_cat_set_low VARCHAR2 (30);

Line 2697: FROM mtl_category_sets

2693:
2694: /* Logic added for inclusion of Category Set Range and dynamic decision on mtl_system_items_b segments by ppandit start */
2695: FOR r_cat IN (
2696: SELECT category_set_id
2697: FROM mtl_category_sets
2698: WHERE category_set_name BETWEEN lc_cat_set_high AND lc_cat_set_low
2699: AND mult_item_cat_assign_flag = 'N'
2700: ORDER BY category_set_id ASC
2701: )

Line 2747: , mtl_category_sets MCS

2743: lc_cat_string := ' AND 1 = 1 ';
2744: END IF;
2745:
2746: v_from_clause := v_from_clause || ', mtl_item_categories MIC
2747: , mtl_category_sets MCS
2748: , mtl_categories_b MCK ';
2749:
2750: v_where_clause := v_where_clause || ' AND MIC.organization_id = ' || p_org_id ||
2751: ' AND MIC.category_set_id = MCS.category_set_id