DBA Data[Home] [Help]

APPS.GMF_MEMO_INTERFACE dependencies on IC_ITEM_MST

Line 161: FROM ic_item_mst

157: t_item_no mtl_system_items.segment1%TYPE;
158:
159: CURSOR get_item_ind(i_item_no VARCHAR2) IS
160: SELECT dualum_ind, lot_ctl
161: FROM ic_item_mst
162: WHERE item_no = i_item_no;
163:
164: t_dualum_ind ic_item_mst.dualum_ind%TYPE;
165: t_lot_ctl ic_item_mst.lot_ctl%TYPE;

Line 164: t_dualum_ind ic_item_mst.dualum_ind%TYPE;

160: SELECT dualum_ind, lot_ctl
161: FROM ic_item_mst
162: WHERE item_no = i_item_no;
163:
164: t_dualum_ind ic_item_mst.dualum_ind%TYPE;
165: t_lot_ctl ic_item_mst.lot_ctl%TYPE;
166:
167: affect_inv EXCEPTION;
168: exp_wrong_item EXCEPTION;

Line 165: t_lot_ctl ic_item_mst.lot_ctl%TYPE;

161: FROM ic_item_mst
162: WHERE item_no = i_item_no;
163:
164: t_dualum_ind ic_item_mst.dualum_ind%TYPE;
165: t_lot_ctl ic_item_mst.lot_ctl%TYPE;
166:
167: affect_inv EXCEPTION;
168: exp_wrong_item EXCEPTION;
169: no_lot_data EXCEPTION;