DBA Data[Home] [Help]

APPS.INV_LOT_APIS dependencies on MTL_GRADES

Line 74: FROM mtl_grades

70: If p_grade_code IS NOT NULL THEN
71: OPEN x_grades FOR
72: SELECT grade_code
73: , description
74: FROM mtl_grades
75: WHERE grade_code LIKE (p_grade_code)
76: AND disable_flag <> 'Y';
77: ELSE
78: OPEN x_grades FOR

Line 81: FROM mtl_grades

77: ELSE
78: OPEN x_grades FOR
79: SELECT grade_code
80: , description
81: FROM mtl_grades
82: WHERE disable_flag <> 'Y';
83: End IF;
84:
85: END get_grade_codes;

Line 424: FROM MTL_GRADES;

420: BEGIN
421: OPEN x_grade_codes FOR
422: SELECT
423: GRADE_CODE , DESCRIPTION
424: FROM MTL_GRADES;
425: END;
426:
427: PROCEDURE get_parent_lot_attributes ( x_lot_att OUT nocopy t_genref
428: , p_inventory_item_id IN NUMBER