DBA Data[Home] [Help]

APPS.GMIVQTY dependencies on IC_LOCT_MST

Line 106: , p_location IN ic_loct_mst.location%TYPE

102: FUNCTION Check_unposted_jnl_lot_status
103: ( p_item_id IN ic_item_mst.item_id%TYPE
104: , p_lot_id IN ic_lots_mst.lot_id%TYPE
105: , p_whse_code IN ic_whse_mst.whse_code%TYPE
106: , p_location IN ic_loct_mst.location%TYPE
107: , p_lot_status IN ic_lots_sts.lot_status%TYPE
108: )
109: RETURN BOOLEAN
110: IS

Line 309: l_to_location ic_loct_mst.location%TYPE;

305: RETURN BOOLEAN
306: IS
307: l_from_whse ic_whse_mst.whse_code%TYPE;
308: l_to_whse ic_whse_mst.whse_code%TYPE;
309: l_to_location ic_loct_mst.location%TYPE;
310: l_from_location ic_loct_mst.location%TYPE;
311: l_count NUMBER;
312: BEGIN
313: l_from_whse := p_qty_rec.from_whse_code;

Line 310: l_from_location ic_loct_mst.location%TYPE;

306: IS
307: l_from_whse ic_whse_mst.whse_code%TYPE;
308: l_to_whse ic_whse_mst.whse_code%TYPE;
309: l_to_location ic_loct_mst.location%TYPE;
310: l_from_location ic_loct_mst.location%TYPE;
311: l_count NUMBER;
312: BEGIN
313: l_from_whse := p_qty_rec.from_whse_code;
314: l_from_location := p_qty_rec.from_location;

Line 334: FROM ic_loct_mst

330: AND l_from_location <> GMIGUTL.IC$DEFAULT_LOCT
331: THEN
332: SELECT 1
333: INTO l_count
334: FROM ic_loct_mst
335: WHERE whse_code = l_from_whse
336: AND location = l_from_location
337: AND delete_mark = 0;
338: END IF;

Line 345: FROM ic_loct_mst

341: AND l_to_location <> GMIGUTL.IC$DEFAULT_LOCT
342: THEN
343: SELECT 1
344: INTO l_count
345: FROM ic_loct_mst
346: WHERE whse_code = l_to_whse
347: AND location = l_to_location
348: AND delete_mark = 0;
349: END IF;