DBA Data[Home] [Help]

APPS.MTL_PARAM_VALIDATE_PKG dependencies on MTL_LOT_NUMBERS

Line 64: from mtl_lot_numbers a, mtl_lot_numbers b

60: if curr_lot_control = 1 then
61: BEGIN
62: select 'uniqueness violated'
63: into v_garbage
64: from mtl_lot_numbers a, mtl_lot_numbers b
65: where a.lot_number = b.lot_number
66: and a.inventory_item_id <> b.inventory_item_id
67: and rownum < 2;
68: