DBA Data[Home] [Help]

APPS.INV_UTILITIES dependencies on MTL_SYSTEM_ITEMS

Line 209: FROM mtl_system_items

205: END IF;
206:
207: SELECT serial_number_control_code
208: INTO serial_control_code
209: FROM mtl_system_items
210: WHERE inventory_item_id = move_ord_rec.inventory_item_id
211: AND organization_id = p_org_id;
212:
213: IF serial_control_code <> 1 THEN

Line 497: FROM MTL_SYSTEM_ITEMS

493: END IF;
494: /*Bug#10279800*/
495: SELECT STOCK_ENABLED_FLAG,INVENTORY_ASSET_FLAG
496: INTO v_stock_enabled_flag,v_inv_asset_flag
497: FROM MTL_SYSTEM_ITEMS
498: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
499: AND ORGANIZATION_ID = p_ship_to_org_id;
500:
501: