APPS.GMI_PRE_MIGRATION dependencies on IC_WHSE_MST

Line 207: FROM ic_loct_inv inv, ic_item_mst_b i, ic_lots_mst l, ic_whse_mst w

203: autolot_active_indicator <> 1;
204:
205: CURSOR c_lot_status IS
206: SELECT i.item_no, l.lot_no, l.sublot_no, w.orgn_code, w.whse_code, inv.location, inv.lot_status
207: FROM ic_loct_inv inv, ic_item_mst_b i, ic_lots_mst l, ic_whse_mst w
208: WHERE
209: inv.whse_code = w.whse_code AND
210: inv.item_id = i.item_id AND
211: i.lot_ctl = 1 AND

Line 217: FROM ic_loct_inv inv2, ic_whse_mst w2

213: inv.lot_id = l.lot_id AND
214: inv.loct_onhand <> 0 AND
215: EXISTS (
216: SELECT 1
217: FROM ic_loct_inv inv2, ic_whse_mst w2
218: WHERE
219: inv.whse_code = w2.whse_code AND
220: inv.item_id = inv2.item_id AND
221: inv.lot_id = inv2.lot_id AND

Line 237: FROM ic_whse_mst) OR

233: FROM mtl_parameters
234: WHERE
235: (organization_id IN (
236: SELECT mtl_organization_id
237: FROM ic_whse_mst) OR
238: organization_id IN (
239: SELECT organization_id
240: FROM ic_whse_mst)) AND
241: lot_number_uniqueness <> 2;

Line 240: FROM ic_whse_mst)) AND

236: SELECT mtl_organization_id
237: FROM ic_whse_mst) OR
238: organization_id IN (
239: SELECT organization_id
240: FROM ic_whse_mst)) AND
241: lot_number_uniqueness <> 2;
242:
243: CURSOR c_org_locator_ctl1 IS
244: SELECT organization_code

Line 249: FROM ic_whse_mst

245: FROM mtl_parameters
246: WHERE
247: (organization_id IN (
248: SELECT mtl_organization_id
249: FROM ic_whse_mst
250: WHERE loct_ctl = 1) OR
251: organization_id IN (
252: SELECT organization_id
253: FROM ic_whse_mst

Line 253: FROM ic_whse_mst

249: FROM ic_whse_mst
250: WHERE loct_ctl = 1) OR
251: organization_id IN (
252: SELECT organization_id
253: FROM ic_whse_mst
254: WHERE loct_ctl = 1)) AND
255: stock_locator_control_code <> 4;
256:
257: CURSOR c_sub_locator_ctl IS

Line 271: FROM ic_whse_mst

267: l.inventory_location_id = ol.inventory_location_id AND
268: s.locator_type <> 5 AND
269: (p.organization_id IN (
270: SELECT mtl_organization_id
271: FROM ic_whse_mst
272: WHERE loct_ctl = 1) OR
273: p.organization_id IN (
274: SELECT organization_id
275: FROM ic_whse_mst

Line 275: FROM ic_whse_mst

271: FROM ic_whse_mst
272: WHERE loct_ctl = 1) OR
273: p.organization_id IN (
274: SELECT organization_id
275: FROM ic_whse_mst
276: WHERE loct_ctl = 1));
277:
278: CURSOR c_org_locator_ctl2 IS
279: SELECT organization_code

Line 284: FROM ic_whse_mst

280: FROM mtl_parameters
281: WHERE
282: (organization_id IN (
283: SELECT mtl_organization_id
284: FROM ic_whse_mst
285: WHERE loct_ctl = 0) OR
286: organization_id IN (
287: SELECT organization_id
288: FROM ic_whse_mst

Line 288: FROM ic_whse_mst

284: FROM ic_whse_mst
285: WHERE loct_ctl = 0) OR
286: organization_id IN (
287: SELECT organization_id
288: FROM ic_whse_mst
289: WHERE loct_ctl = 0)) AND
290: stock_locator_control_code <> 1;
291:
292: CURSOR c_neg_balances IS