APPS.PMI_COST_ANALZ_PACK dependencies on IC_LOCT_INV

Line 167: FUNCTION gmca_get_onhandqty(p_whse_code IN ic_loct_inv.whse_code%TYPE,

163: return l_meaning;
164: END gmca_get_meaning;
165:
166:
167: FUNCTION gmca_get_onhandqty(p_whse_code IN ic_loct_inv.whse_code%TYPE,
168: p_item_id IN ic_loct_inv.item_id%TYPE,
169: P_Location IN ic_loct_inv.location%TYPE,
170: p_lot_id IN ic_loct_inv.lot_id%TYPE ) RETURN NUMBER IS
171: CURSOR get_onhand_cur IS

Line 168: p_item_id IN ic_loct_inv.item_id%TYPE,

164: END gmca_get_meaning;
165:
166:
167: FUNCTION gmca_get_onhandqty(p_whse_code IN ic_loct_inv.whse_code%TYPE,
168: p_item_id IN ic_loct_inv.item_id%TYPE,
169: P_Location IN ic_loct_inv.location%TYPE,
170: p_lot_id IN ic_loct_inv.lot_id%TYPE ) RETURN NUMBER IS
171: CURSOR get_onhand_cur IS
172: SELECT item_id,

Line 169: P_Location IN ic_loct_inv.location%TYPE,

165:
166:
167: FUNCTION gmca_get_onhandqty(p_whse_code IN ic_loct_inv.whse_code%TYPE,
168: p_item_id IN ic_loct_inv.item_id%TYPE,
169: P_Location IN ic_loct_inv.location%TYPE,
170: p_lot_id IN ic_loct_inv.lot_id%TYPE ) RETURN NUMBER IS
171: CURSOR get_onhand_cur IS
172: SELECT item_id,
173: sum(loct_onhand)

Line 170: p_lot_id IN ic_loct_inv.lot_id%TYPE ) RETURN NUMBER IS

166:
167: FUNCTION gmca_get_onhandqty(p_whse_code IN ic_loct_inv.whse_code%TYPE,
168: p_item_id IN ic_loct_inv.item_id%TYPE,
169: P_Location IN ic_loct_inv.location%TYPE,
170: p_lot_id IN ic_loct_inv.lot_id%TYPE ) RETURN NUMBER IS
171: CURSOR get_onhand_cur IS
172: SELECT item_id,
173: sum(loct_onhand)
174: FROM ic_loct_inv

Line 174: FROM ic_loct_inv

170: p_lot_id IN ic_loct_inv.lot_id%TYPE ) RETURN NUMBER IS
171: CURSOR get_onhand_cur IS
172: SELECT item_id,
173: sum(loct_onhand)
174: FROM ic_loct_inv
175: WHERE p_item_id = item_id AND
176: (p_whse_code IS NULL OR (p_whse_code is not null and p_whse_code = whse_code)) AND
177: (p_location IS NULL OR (p_location is not null and p_location = location)) AND
178: (p_lot_id IS NULL OR (p_lot_id is not null and p_lot_id = lot_id))

Line 180: l_item_id ic_loct_inv.item_id%TYPE;

176: (p_whse_code IS NULL OR (p_whse_code is not null and p_whse_code = whse_code)) AND
177: (p_location IS NULL OR (p_location is not null and p_location = location)) AND
178: (p_lot_id IS NULL OR (p_lot_id is not null and p_lot_id = lot_id))
179: group by item_id;
180: l_item_id ic_loct_inv.item_id%TYPE;
181: l_qty NUMBER;
182: BEGIN
183: OPEN get_onhand_cur;
184: FETCH get_onhand_cur INTO l_item_id,l_qty; --get the value from gem lookups