APPS.GMD_SPEC_MATCH_GRP dependencies on MTL_SYSTEM_ITEMS_B

Line 61: l_item_default_grade_code MTL_SYSTEM_ITEMS_B.DEFAULT_GRADE%TYPE ;

57: RETURN BOOLEAN IS
58:
59: l_position VARCHAR2(3);
60: l_grade_ctl VARCHAR2(1);
61: l_item_default_grade_code MTL_SYSTEM_ITEMS_B.DEFAULT_GRADE%TYPE ;
62: l_check_for_given_grade VARCHAR2(1) := 'N';
63: l_check_for_null_grade VARCHAR2(1) := 'N';
64: l_check_for_default_grade VARCHAR2(1) := 'N';
65:

Line 153: FROM mtl_system_items_b

149:
150: IF p_inventory_spec_rec.grade_code IS NULL THEN
151: BEGIN
152: SELECT grade_control_flag, default_grade INTO l_grade_ctl ,l_item_default_grade_code
153: FROM mtl_system_items_b
154: WHERE inventory_item_id = p_inventory_spec_rec.inventory_item_id
155: AND organization_id = p_inventory_spec_rec.organization_id;
156:
157: IF l_grade_ctl = 'N' THEN

Line 537: l_item_default_grade_code MTL_SYSTEM_ITEMS_B.DEFAULT_GRADE%TYPE ;

533:
534:
535: l_position VARCHAR2(3);
536: l_grade_ctl VARCHAR2(1) ;
537: l_item_default_grade_code MTL_SYSTEM_ITEMS_B.DEFAULT_GRADE%TYPE ;
538: l_check_for_given_grade VARCHAR2(1) := 'N';
539: l_check_for_null_grade VARCHAR2(1) := 'N';
540: l_check_for_default_grade VARCHAR2(1) := 'N';
541: l_recipe_no GMD_RECIPES_B.recipe_no%TYPE;

Line 781: FROM mtl_system_items_b

777:
778: IF p_wip_spec_rec.grade_code IS NULL THEN
779: BEGIN
780: SELECT grade_control_flag, default_grade INTO l_grade_ctl ,l_item_default_grade_code
781: FROM mtl_system_items_b
782: WHERE inventory_item_id = p_wip_spec_rec.inventory_item_id
783: AND organization_id = p_wip_spec_rec.organization_id;
784:
785: IF l_grade_ctl = 'N' THEN