DBA Data[Home] [Help]

APPS.GMI_PRE_MIGRATION dependencies on MTL_PARAMETERS

Line 233: FROM mtl_parameters

229: ORDER by i.item_no, l.lot_no, l.sublot_no, w.orgn_code, w.whse_code, inv.location;
230:
231: CURSOR c_lot_uniqeness IS
232: SELECT organization_code
233: FROM mtl_parameters
234: WHERE
235: (organization_id IN (
236: SELECT mtl_organization_id
237: FROM ic_whse_mst) OR

Line 245: FROM mtl_parameters

241: lot_number_uniqueness <> 2;
242:
243: CURSOR c_org_locator_ctl1 IS
244: SELECT organization_code
245: FROM mtl_parameters
246: WHERE
247: (organization_id IN (
248: SELECT mtl_organization_id
249: FROM ic_whse_mst

Line 259: FROM mtl_parameters p,

255: stock_locator_control_code <> 4;
256:
257: CURSOR c_sub_locator_ctl IS
258: SELECT distinct p.organization_code, s.secondary_inventory_name
259: FROM mtl_parameters p,
260: mtl_secondary_inventories s,
261: mtl_item_locations l,
262: ic_loct_mst ol
263: WHERE

Line 280: FROM mtl_parameters

276: WHERE loct_ctl = 1));
277:
278: CURSOR c_org_locator_ctl2 IS
279: SELECT organization_code
280: FROM mtl_parameters
281: WHERE
282: (organization_id IN (
283: SELECT mtl_organization_id
284: FROM ic_whse_mst