DBA Data[Home] [Help]

APPS.GMIUTILS dependencies on IC_LOTS_MST

Line 295: l_lot_no ic_lots_mst.lot_no%TYPE;

291: IS
292:
293: l_item_mst_rec ic_item_mst%ROWTYPE;
294: l_loct_inv_rec ic_loct_inv%ROWTYPE;
295: l_lot_no ic_lots_mst.lot_no%TYPE;
296: l_sublot_no ic_lots_mst.sublot_no%TYPE;
297: l_sts_ctl NUMBER;
298: l_net NUMBER;
299: l_ord NUMBER;

Line 296: l_sublot_no ic_lots_mst.sublot_no%TYPE;

292:
293: l_item_mst_rec ic_item_mst%ROWTYPE;
294: l_loct_inv_rec ic_loct_inv%ROWTYPE;
295: l_lot_no ic_lots_mst.lot_no%TYPE;
296: l_sublot_no ic_lots_mst.sublot_no%TYPE;
297: l_sts_ctl NUMBER;
298: l_net NUMBER;
299: l_ord NUMBER;
300: l_ship NUMBER;

Line 319: ic_lots_mst

315: Cursor get_lot_no(V_lot_id IN NUMBER) IS
316: SELECT
317: lot_no, sublot_no
318: FROM
319: ic_lots_mst
320: WHERE
321: lot_id = V_lot_id;
322:
323: BEGIN