DBA Data[Home] [Help]

APPS.GMI_PURGE_EMPTY_BAL_PKG dependencies on IC_WHSE_MST

Line 35: l_whse_code ic_whse_mst.whse_code%type;

31: l_cursor_id INTEGER;
32: l_dummy INTEGER;
33: l_select_stmt LONG;
34: l_item_no ic_item_mst.item_no%TYPE;
35: l_whse_code ic_whse_mst.whse_code%type;
36: l_location ic_loct_mst.location%type;
37: l_row_id VARCHAR2(100);
38: l_lot_no ic_lots_mst.lot_no%type;
39: l_from_item ic_item_mst.item_no%type;

Line 41: l_from_whse ic_whse_mst.whse_code%type;

37: l_row_id VARCHAR2(100);
38: l_lot_no ic_lots_mst.lot_no%type;
39: l_from_item ic_item_mst.item_no%type;
40: l_to_item ic_item_mst.item_no%type;
41: l_from_whse ic_whse_mst.whse_code%type;
42: l_to_whse ic_whse_mst.whse_code%type;
43: l_inv_class VARCHAR2(10);
44: l_lot_ind NUMBER;
45: l_purg_rec Cur_get_purg_info%rowtype;

Line 42: l_to_whse ic_whse_mst.whse_code%type;

38: l_lot_no ic_lots_mst.lot_no%type;
39: l_from_item ic_item_mst.item_no%type;
40: l_to_item ic_item_mst.item_no%type;
41: l_from_whse ic_whse_mst.whse_code%type;
42: l_to_whse ic_whse_mst.whse_code%type;
43: l_inv_class VARCHAR2(10);
44: l_lot_ind NUMBER;
45: l_purg_rec Cur_get_purg_info%rowtype;
46: l_loct_onhand2 NUMBER;