APPS.GMD_SPEC_MATCH_GRP dependencies on MTL_SYSTEM_ITEMS_B

Line 58: l_item_default_grade_code MTL_SYSTEM_ITEMS_B.DEFAULT_GRADE%TYPE ;

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

Line 150: FROM mtl_system_items_b

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

Line 534: l_item_default_grade_code MTL_SYSTEM_ITEMS_B.DEFAULT_GRADE%TYPE ;

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

Line 778: FROM mtl_system_items_b

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