DBA Data[Home] [Help]

APPS.MRP_VALIDATE_ASSIGNMENT dependencies on MTL_CATEGORY_SETS

Line 967: mtl_category_sets mcs

963: ELSE
964: SELECT count(*)
965: INTO l_count
966: FROM mtl_categories mc,
967: mtl_category_sets mcs
968: WHERE mcs.category_set_id = p_Category_Set_Id
969: AND mc.structure_id = mcs.structure_id
970: AND mc.category_id = p_Category_Id;
971:

Line 1003: FROM MTL_CATEGORY_SETS

999: RETURN TRUE;
1000: ELSE
1001: SELECT count(*)
1002: INTO l_count
1003: FROM MTL_CATEGORY_SETS
1004: WHERE category_set_id = p_Category_Set_Id;
1005:
1006: IF l_count = 0 THEN
1007: dbms_output.put_line ('Val_Category_Set_Id Error');