APPS.GMD_SPEC_MATCH_MIG_GRP dependencies on IC_ITEM_MST_B

Line 162: FROM IC_ITEM_MST_B

158:
159: IF p_inventory_spec_rec.grade IS NULL THEN
160: BEGIN
161: SELECT grade_ctl,qc_grade INTO l_grade_ctl ,l_item_default_grade
162: FROM IC_ITEM_MST_B
163: WHERE ITEM_ID = p_inventory_spec_rec.item_id ;
164:
165: IF l_grade_ctl = 0 THEN
166: l_check_for_null_grade := 'Y';

Line 404: FROM IC_ITEM_MST_B

400:
401: IF p_customer_spec_rec.grade IS NULL THEN
402: BEGIN
403: SELECT grade_ctl,qc_grade INTO l_grade_ctl ,l_item_default_grade
404: FROM IC_ITEM_MST_B
405: WHERE ITEM_ID = p_customer_spec_rec.item_id ;
406:
407: IF l_grade_ctl = 0 THEN
408: l_check_for_null_grade := 'Y';

Line 796: FROM IC_ITEM_MST_B

792:
793: IF p_wip_spec_rec.grade IS NULL THEN
794: BEGIN
795: SELECT grade_ctl,qc_grade INTO l_grade_ctl ,l_item_default_grade
796: FROM IC_ITEM_MST_B
797: WHERE ITEM_ID = p_wip_spec_rec.item_id ;
798:
799: IF l_grade_ctl = 0 THEN
800: l_check_for_null_grade := 'Y';

Line 1086: FROM IC_ITEM_MST_B

1082:
1083: IF p_supplier_spec_rec.grade IS NULL THEN
1084: BEGIN
1085: SELECT grade_ctl,qc_grade INTO l_grade_ctl ,l_item_default_grade
1086: FROM IC_ITEM_MST_B
1087: WHERE ITEM_ID = p_supplier_spec_rec.item_id ;
1088:
1089: IF l_grade_ctl = 0 THEN
1090: l_check_for_null_grade := 'Y';