APPS.GML_MOBILE_RECEIPT dependencies on IC_ITEM_MST

Line 20: v_item_rec IC_ITEM_MST%ROWTYPE;

16:
17: v_location VARCHAR2(20);
18: v_opm_item_id NUMBER;
19: v_inv_lot_status VARCHAR2(5) := NULL;
20: v_item_rec IC_ITEM_MST%ROWTYPE;
21: v_inv_loct_onhand NUMBER := 0;
22:
23: v_processing_mode VARCHAR2(15);
24:

Line 52: FROM ic_item_mst

48: v_opm_item_id := p_item_id;
49:
50: SELECT *
51: INTO v_item_rec
52: FROM ic_item_mst
53: WHERE item_id = v_opm_item_id;
54:
55: IF p_locator_id > 0 THEN
56: SELECT location

Line 246: from ic_lots_mst a, ic_item_mst b

242:
243:
244: OPEN x_lot_lov FOR
245: select a.lot_no,a.sublot_no,a.expire_date,a.lot_id
246: from ic_lots_mst a, ic_item_mst b
247: where a.item_id= p_item_id
248: and a.lot_id <> 0
249: and a.lot_no like (p_lot_no)
250: and a.delete_mark=0

Line 3197: From ic_item_mst ilm

3193: Cursor Cr_get_opm_attr IS
3194: Select ilm.item_id,
3195: ilm.dualum_ind,
3196: ilm.item_um2
3197: From ic_item_mst ilm
3198: Where ilm.item_no = p_item_no;
3199:
3200: CURSOR Get_Lot_Id (p_item_id NUMBER) IS
3201: SELECT lot_id