APPS.GMI_SHIPPING_UTIL dependencies on IC_LOTS_MST

Line 167: FROM ic_lots_mst

163: ELSIF p_shipping_line.sublot_number IS NULL
164: -- HW BUG#:1727553 added sublot_no is NULL
165: THEN
166: SELECT lot_id INTO l_lot_id
167: FROM ic_lots_mst
168: WHERE item_id = l_item_id
169: AND lot_no = p_shipping_line.lot_number
170: AND sublot_no IS NULL ;
171: ELSE

Line 173: FROM ic_lots_mst

169: AND lot_no = p_shipping_line.lot_number
170: AND sublot_no IS NULL ;
171: ELSE
172: SELECT lot_id INTO l_lot_id
173: FROM ic_lots_mst
174: WHERE item_id = l_item_id
175: AND lot_no = p_shipping_line.lot_number
176: AND sublot_no = p_shipping_line.sublot_number;
177: END IF;

Line 893: FROM ic_lots_mst

889: ELSIF p_shipping_line.sublot_number IS NULL
890: /*HW BUG#:1727553 added sublot_no is NULL */
891: THEN
892: SELECT lot_id INTO l_lot_id
893: FROM ic_lots_mst
894: WHERE item_id = l_item_id
895: AND lot_no = p_shipping_line.lot_number
896: AND sublot_no IS NULL ;
897: ELSE

Line 899: FROM ic_lots_mst

895: AND lot_no = p_shipping_line.lot_number
896: AND sublot_no IS NULL ;
897: ELSE
898: SELECT lot_id INTO l_lot_id
899: FROM ic_lots_mst
900: WHERE item_id = l_item_id
901: AND lot_no = p_shipping_line.lot_number
902: AND sublot_no = p_shipping_line.sublot_number;
903: END IF;

Line 2109: FROM ic_lots_mst

2105: l_lot_id := 0;
2106: ELSIF p_sublot_number IS NULL
2107: THEN
2108: SELECT lot_id INTO l_lot_id
2109: FROM ic_lots_mst
2110: WHERE item_id = l_item_id
2111: AND lot_no = p_lot_number
2112: AND sublot_no IS NULL ;
2113: ELSE

Line 2115: FROM ic_lots_mst

2111: AND lot_no = p_lot_number
2112: AND sublot_no IS NULL ;
2113: ELSE
2114: SELECT lot_id INTO l_lot_id
2115: FROM ic_lots_mst
2116: WHERE item_id = l_item_id
2117: AND lot_no = p_lot_number
2118: AND sublot_no = p_sublot_number;
2119: END IF;

Line 3248: FROM ic_lots_mst

3244: l_lot_id := 0;
3245: ELSIF lines.sublot_number IS NULL
3246: THEN
3247: SELECT lot_id INTO l_lot_id
3248: FROM ic_lots_mst
3249: WHERE item_id = l_item_id
3250: AND lot_no = lines.lot_number
3251: AND sublot_no IS NULL ;
3252: ELSE

Line 3254: FROM ic_lots_mst

3250: AND lot_no = lines.lot_number
3251: AND sublot_no IS NULL ;
3252: ELSE
3253: SELECT lot_id INTO l_lot_id
3254: FROM ic_lots_mst
3255: WHERE item_id = l_item_id
3256: AND lot_no = lines.lot_number
3257: AND sublot_no = lines.sublot_number;
3258: END IF;