[Home] [Help]
4332: AND moqd.inventory_item_id = p_inventory_item_id
4333: AND moqd.subinventory_code = p_subinventory_code
4334: AND nvl(moqd.locator_id,-999) = nvl(p_locator_id,-999)
4335: AND nvl(moqd.lot_number,-999) = nvl(p_lot_number, -999)
4336: AND NOT EXISTS(SELECT 1 from mtl_status_transaction_control mtc
4337: WHERE mtc.status_id = moqd.status_id
4338: AND mtc.transaction_type_id = p_transaction_type_id
4339: AND mtc.is_allowed = 2 ));
4340: EXCEPTION