APPS.GMI_WF_LOT_RETEST dependencies on IC_LOCT_INV

Line 308: l_sum_loct_onhand ic_loct_inv.loct_onhand%TYPE := 0 ;

304: p_resultout OUT NOCOPY VARCHAR2
305: )
306: IS
307: l_count_lots_mst NUMBER := 0;
308: l_sum_loct_onhand ic_loct_inv.loct_onhand%TYPE := 0 ;
309: l_sum_loct_onhand2 ic_loct_inv.loct_onhand2%TYPE := 0 ;
310:
311: l_lot_id ic_lots_mst.lot_id%TYPE := TO_NUMBER(LTRIM(p_itemkey,'RT')) ;
312: l_lot_no ic_lots_mst.lot_no%TYPE ;

Line 309: l_sum_loct_onhand2 ic_loct_inv.loct_onhand2%TYPE := 0 ;

305: )
306: IS
307: l_count_lots_mst NUMBER := 0;
308: l_sum_loct_onhand ic_loct_inv.loct_onhand%TYPE := 0 ;
309: l_sum_loct_onhand2 ic_loct_inv.loct_onhand2%TYPE := 0 ;
310:
311: l_lot_id ic_lots_mst.lot_id%TYPE := TO_NUMBER(LTRIM(p_itemkey,'RT')) ;
312: l_lot_no ic_lots_mst.lot_no%TYPE ;
313: l_sublot_no ic_lots_mst.sublot_no%TYPE ;

Line 342: FROM ic_loct_inv

338: IF l_continue_execution THEN
339:
340: SELECT nvl(SUM(loct_onhand),0) , nvl(SUM(loct_onhand2),0)
341: INTO l_sum_loct_onhand, l_sum_loct_onhand2
342: FROM ic_loct_inv
343: WHERE lot_id = l_lot_id;
344: IF (
345: ( ( l_sum_loct_onhand + l_sum_loct_onhand2 ) = 0 )
346: )THEN