DBA Data[Home] [Help]

APPS.WIP_COMMON dependencies on MTL_SYSTEM_ITEMS

Line 373: from mtl_system_items

369: x_rev_exists number := 0;
370: begin
371:
372: select revision_qty_control_code into x_rev_exists
373: from mtl_system_items
374: where inventory_item_id = p_item_id
375: and organization_id = p_Org_id ;
376:
377:

Line 440: FROM mtl_system_items

436: p_pri_uom in out nocopy varchar2) return number is
437: begin
438:
439: Select PRIMARY_UOM_CODE INTO p_pri_uom
440: FROM mtl_system_items
441: WHERE inventory_item_Id = p_item_id
442: AND organization_Id = p_org_id;
443:
444: if (p_txn_uom = p_pri_uom) then