DBA Data[Home] [Help]

APPS.INV_ITEM_CATEGORY_PVT dependencies on MTL_CATEGORY_SETS_B

Line 97: FROM mtl_category_sets_b

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

Line 612: FROM mtl_category_sets_b

608:
609: CURSOR category_sets_csr (p_category_set_id NUMBER)
610: IS
611: SELECT control_level,default_category_id--Bug:2527058
612: FROM mtl_category_sets_b
613: WHERE category_set_id = p_category_set_id;
614:
615: CURSOR category_exists_csr (p_category_id NUMBER)
616: IS

Line 1100: FROM mtl_category_sets_b

1096: validate_flag,
1097: mult_item_cat_assign_flag,
1098: control_level,
1099: hierarchy_enabled
1100: FROM mtl_category_sets_b
1101: WHERE category_set_id = p_category_set_id;
1102:
1103: CURSOR category_set_valid_cats_csr
1104: ( p_category_set_id NUMBER