DBA Data[Home] [Help]

APPS.WIP_COMMON dependencies on MTL_SYSTEM_ITEMS

Line 318: from mtl_system_items

314: x_rev_exists number := 0;
315: begin
316:
317: select revision_qty_control_code into x_rev_exists
318: from mtl_system_items
319: where inventory_item_id = p_item_id
320: and organization_id = p_Org_id ;
321:
322:

Line 385: FROM mtl_system_items

381: p_pri_uom in out nocopy varchar2) return number is
382: begin
383:
384: Select PRIMARY_UOM_CODE INTO p_pri_uom
385: FROM mtl_system_items
386: WHERE inventory_item_Id = p_item_id
387: AND organization_Id = p_org_id;
388:
389: if (p_txn_uom = p_pri_uom) then