DBA Data[Home] [Help]

APPS.GMIUTILS dependencies on IC_LOCT_INV

Line 214: FROM ic_loct_inv

210: v_whse IN VARCHAR2,
211: v_lot_id IN NUMBER,
212: v_location IN VARCHAR2) IS
213: SELECT loct_onhand, loct_onhand2
214: FROM ic_loct_inv
215: WHERE item_id = v_item_id
216: AND whse_code = v_whse
217: AND lot_id = v_lot_id
218: AND location = v_location;

Line 294: l_loct_inv_rec ic_loct_inv%ROWTYPE;

290: RETURN BOOLEAN
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;

Line 341: x_ic_loct_inv_row => l_loct_inv_rec

337: p_item_id => p_item_id,
338: p_whse_code => p_whse_code,
339: p_lot_id => p_lot_id,
340: p_location => p_location,
341: x_ic_loct_inv_row => l_loct_inv_rec
342: );
343:
344: IF (p_doc_type = 'PROD') AND (p_trans_qty > 0) THEN
345: /* begin move diff status check for production */