DBA Data[Home] [Help]

APPS.INV_ITEM_CATEGORY_PVT dependencies on MTL_CATEGORY_SETS_B

Line 96: FROM mtl_category_sets_b

92: IS
93: SELECT structure_id, validate_flag, mult_item_cat_assign_flag,
94: control_level
95: ,hierarchy_enabled--Bug: 2996160
96: FROM mtl_category_sets_b
97: WHERE category_set_id = p_category_set_id;
98:
99: CURSOR category_exists_csr (p_category_id NUMBER)
100: IS

Line 602: FROM mtl_category_sets_b

598:
599: CURSOR category_sets_csr (p_category_set_id NUMBER)
600: IS
601: SELECT control_level,default_category_id--Bug:2527058
602: FROM mtl_category_sets_b
603: WHERE category_set_id = p_category_set_id;
604:
605: CURSOR category_exists_csr (p_category_id NUMBER)
606: IS

Line 1088: FROM mtl_category_sets_b

1084: validate_flag,
1085: mult_item_cat_assign_flag,
1086: control_level,
1087: hierarchy_enabled
1088: FROM mtl_category_sets_b
1089: WHERE category_set_id = p_category_set_id;
1090:
1091: CURSOR category_set_valid_cats_csr
1092: ( p_category_set_id NUMBER