APPS.GMI_WF_LOT_CM dependencies on IC_ITEM_MST

Line 13: l_lot_ctl ic_item_mst.lot_ctl%TYPE ;

9: FROM ic_lots_mst
10: WHERE delete_mark = 0 AND inactive_ind = 0
11: FOR UPDATE; -- table is NOT updated, see NOTES section above
12:
13: l_lot_ctl ic_item_mst.lot_ctl%TYPE ;
14: l_grade_ctl ic_item_mst.grade_ctl%TYPE ;
15:
16:
17: l_date_at_start DATE ;

Line 14: l_grade_ctl ic_item_mst.grade_ctl%TYPE ;

10: WHERE delete_mark = 0 AND inactive_ind = 0
11: FOR UPDATE; -- table is NOT updated, see NOTES section above
12:
13: l_lot_ctl ic_item_mst.lot_ctl%TYPE ;
14: l_grade_ctl ic_item_mst.grade_ctl%TYPE ;
15:
16:
17: l_date_at_start DATE ;
18: l_notify_date DATE ;

Line 56: FROM ic_item_mst

52: LOOP
53:
54: SELECT lot_ctl,grade_ctl
55: INTO l_lot_ctl,l_grade_ctl
56: FROM ic_item_mst
57: WHERE item_id = ic_lots_mst_record.item_id
58: AND delete_mark = 0 ;
59:
60: